Database Administration (MOSC)

MOSC Banner

log mining session info "unknown"

edited Dec 15, 2012 8:05PM in Database Administration (MOSC) 2 commentsAnswered
hi all,
we are using 10.2.0.4 on AIX 5.3 and one of the tables have been updated with incorrect information by one of the application users. we have done log mining to find out which user might have done that.

The session information is shown as "UNKNOWN" however, we are able to see the problematic SQL query from the log miner output. why is the session information shown as "unknown" and is there any other way for us to find who might have updated the table?

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