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!

Trace a terminated session

user3715462Nov 11 2010 — edited Nov 11 2010

Hi All,

OUL5
database 11gR1 11.1.0.7
a session was blocking another session with status "WAITING"
After terminated the blocking session using kill with SID and SERIAL#
the system was running normal, now i like to go back and try to figure out
what the blocking session was doing at that time.
Please advise how to trace a terminated session.
Thanks for your assistance.
Regards,

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 9 2010

Added on Nov 11 2010

#general-database-discussions

6 comments

665 views