SQL> set autotrace on SQL> select * from scott.emp where empno=7900;
v_$sesstat
v_$ statname
v_$mystat
SQL> @?/sqlplus/admin/plustrace.sql SQL> grant plustrace to scott;