search cancel

Database limit Usage Alert

book

Article ID: 214461

calendar_today

Updated On:

Products

CA Workload Automation AE

Issue/Introduction

There are inactive user session from WCCDBADMIN and AUTOSYS. How should these be removed.

 

There are below inactive sessions observed:

USERNAME                            STATUS     COUNT(*)

---------------------------------------- -------- ----------

AUTOSYS                            INACTIVE        120

WCCDBADMIN                   INACTIVE         80

 

 

 

Environment

Release : 11.3.6

Component : WORKLOAD CONTROL CENTER

Resolution

Please stop the AutoSys and WCC products, then if there are still leftover sessions consult the DBA to assist in removing them.

 

Something like...

1. login to database as SA.

2.  Check all the sessions that are inactive that owned by a db userid.
SELECT SID, SERIAL#, STATUS, SERVER FROM V$SESSION WHERE USERNAME = '<username>';

3.  To kill the sessio via alter command. Make sure you are entering the sid ahd serial# of the inactive session.

ALTER SYSTEM KILL SESSION '<sid, serial#>'

4.Recheck if there are any further inactive sessions.

SELECT SID, SERIAL#, STATUS, SERVER FROM V$SESSION WHERE USERNAME = '<username>'