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!

How to find the session info using the Unix PID

451840Jun 29 2009 — edited Jun 29 2009

Hi Guys
We found in alert log that Some process with Unix pid 3416182 makes some transaction fail. It happened on weekend and now when we try to find it in v$process we did not find any info. Is there any place where oracle stores the PID History where in i would be able to find which process,session,user caused the transaction failure.

Kindly help me. I m using oracle 10G R2.

Thanks in advance
Ram

Edited by: user448837 on Jun 29, 2009 2:04 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 27 2009

Added on Jun 29 2009

#general-database-discussions

3 comments

491 views