Sql> SET autotrace on STATISTICS;
SP2-0618: The session identifier could not be found. Enable Check Plustrace role
sp2-0611: Error while enabling STATISTICS reporting
Solution:
Log in as a SYSDBA user and run two scripts:
Sql> @e:\oracle\product\10.2.0\db_1\rdbms\admin\utlxplan.sql
Table has been created.
sql> @ e:\oracle\product\10.2.0\db_1\sqlplus\admin\plustrce.sql
Assigning permissions to a user
Sql> Grant plustrace to public;
The authorization was successful.
Connect again, it's okay.
Sql> Conn Scott/tiger;
is connected.
Sql> set autotrace on statistics;
...... Query results omitted ...
Statistics
----------------------------------------------------------
1 Recursive calls
0 db block gets
8 &nbs P;consistent gets
0 physical reads
0 & Nbsp;redo size
1364 bytes sent via sql*net to client
bytes received via sql*net from client
2 sql*net roundtrips To/from Client
0 sorts (memory)
0 sorts (disk)
14 rows processed