Skip to Main Content

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 grant common user for generating 10053 events on Oracle ?

Quanwen ZhaoJan 2 2018 — edited Jan 2 2018

Hello,

experts

I want to use 10053 events to view a sql statement's executing process and details on common user - TEST in my Oracle DB,when I execute 'alter session set events '10053 ......'' and it shows error below,

TEST@ora11gr2> alter session set tracefile_identifier='10053';

Session altered.

TEST@ora11gr2> alter session set events '10053 trace name context forever';

ERROR:

ORA-01031: insufficient privilege.

Now,how to grant common user for generating 10053 events on Oracle (11.2.0.4.0 for Windows x64) for me ? Thanks!

Best Regards

Quanwen Zhao

This post has been answered by John Thorton on Jan 2 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 30 2018
Added on Jan 2 2018
2 comments
965 views