find machine that executed a certain sql_id
545955Dec 29 2006 — edited Dec 29 2006I 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?