Database Administration (MOSC)

MOSC Banner

Supplemental logging to populate User details in V$LOGMNR_CONTENTS

edited Feb 19, 2015 10:02AM in Database Administration (MOSC) 3 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center