-
How to identify sessions that are not closing?
I thought by joining v$session and v$sqlarea, I can get the last run sql statment for a session. However, the fact I get 90% of sessions point to the same statement "SELECT VALUE FROM NLS_INSTANCE_PARAMETERS WHERE PARAMETER ='NLS_DATE_FORMAT'" makes me wonder if I am doing the right thing.
The reason I want to do this is because I keep getting max number of processes exceeded error and I see alot of inactive sessions with the above sql statement when joining v$session and v$sqlarea.
Thanks,
Last edited by a128; 12-22-2003 at 10:44 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|