Oralce 12c SP2-0618 and ORA-01919
I met the error SP2-0618 and ORA-01919 while I executed the command “set autot on” to check the execute plan of sql.
HR@PDBPROD1> set autot on SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled SP2-0611: Error enabling STATISTICS report HR@PDBPROD1>
I used sys to grant the PLUSTRACE role to user(HR). There was ORA-01919 error.
SYS@PDBPROD1> grant PLUSTRACE to hr; grant PLUSTRACE to hr * ERROR at line 1: ORA-01919: role 'PLUSTRACE' does not exist SYS@PDBPROD1>
Regarding to this error solution, we can referent to the following document.
Controlling the Autotrace Report
Example 8-2 Creating the PLUSTRACE Role
Run the following commands from your SQL*Plus session to create the PLUSTRACE role and grant it to the DBA: CONNECT / AS SYSDBA @$ORACLE_HOME/sqlplus/admin/plustrce.sql
After HR user have PLUSTRACE role, need to re-create session to execute the “set autot on”.
++++++++++++++++ EOF LinHong ++++++++++++++++