Supplemental logging to populate User details in V$LOGMNR_CONTENTS
We are using logmnr to analyze redo logs to find who performed a particular deleted operation on a specific table.
However, V$LOGMNR_CONTENTS is returning "UNKNOWN" for USERNAME,OS_USERNAME and SESSION columns.
Can someone tell me what kind of supplemental logging should be enabled to get the user information also will there be any performance impact on the database if we enable the supplemental logging.
Thanks.