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!

Mapping OS process with Oracle session

QuEST TeamJan 9 2011 — edited Jan 9 2011

Hi,
I have sever performance issue with the database (db - 10.2.0.4 and OS is AIX 5.3). When i do a topas (AIX command to check the processes). I see one process id 1569224 which is taking the max cpu and mem.

How do i check what is the corresponding session for this process? I tried :

select * from v$session where process=1569224

This does not return any rows. How to check?

Regards,
ARS

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 6 2011

Added on Jan 9 2011

#general-database-discussions

2 comments

565 views