SQL & PL/SQL

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!

find machine that executed a certain sql_id

545955Dec 29 2006 — edited Dec 29 2006

I have a sql_id and I need to see which machine executed it and when. The query has been causing ORA-01555 and I find it once in awhile. It ran today about 10 hours ago, can I find the machine that executed it and approach the user about this?

How do I get the machine from an execution of a known sql_id where the session is not current?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 26 2007

Added on Dec 29 2006

2 comments

762 views