Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

How to check what session locked my User - database oracle

edited Feb 25, 2016 4:01AM in Database Install/Upgrade/Opatch (MOSC) 6 commentsAnswered ✓

Hello,

I want to check what user, sql_text  and session locked my useroracle.

I try to use  this request  "select * from dba_audit_trail where returncode = 1017 and username = 'USERFR' order by TIMESTAMP desc ";

to check the session.

Regards,

Six

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