Oracle Database Discussions

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!

To get SESSION information using logminer

N_RajSep 25 2013 — edited Sep 25 2013

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 23 2013

Added on Sep 25 2013

#general-database-discussions

2 comments

547 views