Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

oracle active sessions

972227May 31 2013 — edited May 31 2013
Hello guys, I am a bit confused here on how to find out the active oracle sessions.
usually to find the active oracle sessions for a particular user, i use the following query.
select from v$session where status='ACTIVE' and username='<username>'*

when I used the above query I got zero results, but when I look at the TOAD session browser, I see one active session for the the user I am querying. The user uses the Informatica to send the query to the database to be executed.

My question is how do i really make sure if the user's session is actually active or not.

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 28 2013
Added on May 31 2013
6 comments
1,807 views