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!

Monitoring Oracle session with SQL_ID

imran khanDec 7 2012 — edited Dec 7 2012

Hi All,

How can I know a SQL_ID belonging to a user/schema in Oracle. Can anyone post me the query to find the SQL QUERY/SQL_ID belonging to a user session. I have googled but dint get what i expected. Hope I get it here. We dont have OEM configured to monitor the session.

Oracle DB version : 10.2.0.5
OS version : IBM - AIX

Regards,
Imran Khan

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 4 2013

Added on Dec 7 2012

#general-database-discussions

18 comments

26,633 views