Home » RDBMS Server » Performance Tuning » PLUSTRACE Role
PLUSTRACE Role [message #65071] Wed, 14 April 2004 22:22 Go to next message
Avi
Messages: 23
Registered: January 2002
Junior Member
Hi Guys,

  I just created pln_table in my local schema. and then tried doing set sqltrace on and it gave me the following error.

Can any body point me to what's that. and what is a plustrace role involve.

Another question round this is that how do we see what privileges are enabled with a particular role.

*****ERROR ON SET AUTOTRACE ON***************

SP2-0618: Cannot find the Session Identifier.  Check PLUSTRACE role is enabled
SP2-0611: Error enabling STATISTICS report
Re: PLUSTRACE Role [message #65074 is a reply to message #65071] Thu, 15 April 2004 05:29 Go to previous messageGo to next message
Frank Naude
Messages: 4578
Registered: April 1998
Senior Member
Hi,

You need to do the following:

SQL> connect SYS AS SYSDBA
SQL> @?/sqlplus/admin/plustrce.sql
SQL> grant plustrace to public;


Best regards.

Frank
Re: PLUSTRACE Role [message #65087 is a reply to message #65074] Sun, 25 April 2004 02:43 Go to previous messageGo to next message
Binu
Messages: 4
Registered: August 2002
Junior Member
If you are using Oracle 9i, executing @?/sqlplus/admin/plustrce.sql won't give proper access to autotrace.

You also need to give select access on v_$mystat view to the Plustrace role.

Best regards,

Binu
Re: PLUSTRACE Role [message #65478 is a reply to message #65074] Fri, 01 October 2004 01:54 Go to previous message
Brad
Messages: 12
Registered: April 1999
Junior Member
PLUSTRACE grants by default SELECT on following tables:

V_$MYSTAT
V_$SESSTAT
V_$STATNAME

ORACLE 9 requires one additional SELECT grant on table:

V_$SESSION
Previous Topic: DB paramater Optimizer Index Cost Adjustment
Next Topic: Buffer Cache Hit Ratio
Goto Forum:
  


Current Time: Thu Feb 29 09:21:49 CST 2024