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.
you can not mine data that has not been logged.