SQL & PL/SQL

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!

Not able to run Alter session set sql_trace=true

523266Jul 14 2006 — edited Jul 17 2006

Because of security constraints my oracle user does not have full sysdba privilages.
when try to run Alter session set sql_trace=true i get a error insufficient privilages in Oracle 10 g.
Basically i want to Generate trace files.
Is there any way to set some parameters for the oracle user to solve this problem.
Or is there any other ways to generate the trace files

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 14 2006

Added on Jul 14 2006

3 comments

2,724 views