Enabling the SQL Trace for a Session

[karthik]

Hi,

When I try to "Enable SQL Trace" for a selected session, I am getting the following error.

"PLS-00201: identifier 'SYS.DBMS_SYSTEM' must be declared"

Can anyone please help me in clearing this problem?

Regards,
Karthik

 

[Marco Kalter]

You are apparently missing the execute privilege on the sys.dbms_system package. To correct this, connect as SYS, open a SQL Window, and run the following:

grant execute on dbms_system to

To grant privileges to all users:

grant execute on dbms_system to public

 

[karthik]

Thanks you Marco!! It worked.

But how can I view the results of the trace or is there any window where the traced information is displayed ?

 

[Marco Kalter]

You will have to run tkprof on the database server to get a profile report. See chapter 5.4 in the User's Guide, and/or the Oracle Database Performance Tuning Guide and Reference.

Note that there are various tuning/tracing functions available. See chapter 5 in the User's Guide.