|
|
abukta
super admin
profile |
|
Join Date: 29 Mar 2005 21:03
Posts: |
|
|
o check user session in your database, you need to look in the V$SESSION view. Why you need to look at this view? Well, when you see a lot of "SNIPED" or "KILLED" sesions and that number does not change over time, you are wasting a number of allowable sessions. The only way to clear this is to restart your database.
select Status, count(*)
from V$SESSION
group by Status
/
Output (example) :
============
STATUS COUNT(*)
--------------------------------------
ACTIVE 20
INACTIVE 160
KILLED 20
CACHED 6
SNIPED 3
|
Home 
Forum
User Session Status
