Skip to Main Content

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?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 26 2007
Added on Dec 29 2006
2 comments
763 views