2 Replies Latest reply: Oct 16, 2013 7:09 AM by user12075536123 RSS

    Find user details using sqlid

    KODS

      Hi All,

       

       

      Here is the scenario.

      I identified the ORA-00600 error in my database alert log file and is caused because of a SQL statement. I am aware of sqlid only.

      I tried to trace the username by using sqlid fron v$session, but did not find the user details as the job is completed already.

      Please let me know is there any way to trace the user details.

      I have 7days AWR snaps available.


      Thanks,
      KODS