DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: find out the last sql statment run associated with a session

Threaded View

  1. #1
    Join Date
    Apr 2001
    Posts
    257

    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
  •  


Click Here to Expand Forum to Full Width