SP2-0618, SP2-0611 autotrace 에러

orcl@HR> set autot on

 

SP2-0618: Cannot find the Session Identifier.  Check PLUSTRACE role is enabled

SP2-0611: Error enabling STATISTICS report

 

 

아래 스크립트를 실행한다.

SQL> @/u01/app/oracle/product/11.2.0/dbhome_1/sqlplus/admin/plustrce.sql

 

권한을 해당 유저에게 할당한다

SQL> grant plustrace to hr;

Grant succeeded.

SQL> conn hr/hr

Connected.

SQL> set autotrace on

SQL>

 

autotrace 실행이 성공했다.