2 Replies Latest reply on Oct 16, 2013 12:09 PM by user12075536123

    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