AUTOTRACE learning for Oracle performance analysis tools

AUTOTRACE for Oracle performance analysis tools is one of the most common performance analysis tools. It is used to view the execution process and resource consumption of SQL statements. The SP2-0618: The session identifier cannot be found. Enable check PLUSTRACE role and SP2-0611: error when STATISTICS reporting is enabled, as shown below:
According to the error message, you need to create a role plustrace in the database and run the script plustrce. SQL by using sys to create the role script in the directory % ORACLE_HOME % \ sqlplus \ admin. Run the following script:
Www.2cto.com and authorize the role plustrace to the mchakin_one user, as follows: Log On again with the current user: Normally, no error is reported. Run the select count (*) from tab; statement to report the ORA-01039: view basic object with insufficient permissions and SP2-0612: An error occurred while generating the autotrace explain report, as shown below: the error message shown above is prompted. This is because autotrace is performed on the System Object (tab), so the following error message is reported. Use the table of the current user: normal.