Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to trace a particular database user ?

johnpau2013Aug 26 2010 — edited Aug 27 2010

Everyone knows that there is an Oracle username "SCOTT" in all the database installation.

How to enable tracing for the SCOTT user, so I can can get all the tracing info of the user SQL's

Note: I know I can get the sid,serial# info and trace a particular session id, but here i wanted to trace the entire user SCOTT, no matter how many Sessions he opens.

Help me with this !!!!

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 24 2010

Added on Aug 26 2010

#general-database-discussions

8 comments

2,688 views