2 Replies Latest reply: Sep 25, 2013 2:27 PM by sb92075 RSS

    To get SESSION information using logminer

    975791

      Hi,

       

      We use Oracle 11R2.

       

      We tried to get SESSION information using log miner.

      But We didn't get USERNAME,OS_USERNAME,MACHINE_NAME,SESSION_INFO(values is UNKNOWN) and client id(values is NULL).

      Supplemental log is not enabled in the database and auditing is not enabled.

      Is there a way to find out the session information from the transaction id(XID). or any other way.

       

      Br,

      Raj