Search This Blog

Monday, July 22, 2013

AUTOTRACE Option in SQL*Plus


 admin]$ sqlplus '/as sysdba'

SQL> @?/sqlplus/admin/plustrce.sql
SQL>
SQL> drop role plustrace;
drop role plustrace
          *
ERROR at line 1:
ORA-01919: role 'PLUSTRACE' does not exist


SQL> create role plustrace;

Role created.

SQL>
SQL> grant select on v_$sesstat to plustrace;

Grant succeeded.

SQL> grant select on v_$statname to plustrace;

Grant succeeded.

SQL> grant select on v_$mystat to plustrace;

Grant succeeded.

SQL> grant plustrace to dba with admin option;

Grant succeeded.

SQL> grant plustrace to xxuser;

Grant succeeded.


GRANTEE                        TYP PRIVILEGE OR ROLE
------------------------------ --- --------------------------------------------------------------------------
XXUSER                              PLUSTRACE


Refer: AUTOTRACE Option in SQL*Plus (Doc ID 43214.1)

No comments:

Post a Comment

Transportable tablespace refresh

  1.check tablespace for the user which need to refresh -------------------------------------------------------------------  SQL> select ...