Oracle Net refers to the generic process communication between SQL*Plus and the server, regardless of whether Oracle Net is installed. The client referred to in the statistics is SQL*Plus. Number of rows processed during the operation Number of sort operations that required at least one disk write Number of sort operations that were performed completely in memory and did not require any disk writes Total number of Oracle Net messages sent to and received from the client Oracle Net Services round-trips to/from client Total number of bytes received from the client over Oracle Net. Total number of bytes sent to the client from the foreground processes.īytes received through Oracle Net Services from client This number equals the value of 'physical reads direct' plus all reads into buffer cache.īytes sent through Oracle Net Services to client

Total number of data blocks read from disk. Number of times a consistent read was requested for a block Number of times a CURRENT block was requested. When Oracle Database needs to make a change to these tables, it internally generates an internal SQL statement, which in turn generates a recursive call. Oracle Database maintains tables used for internal processing.

Number of recursive calls generated at both the user and system level. For information on how to grant a role and how to create the PLAN_TABLE table, see the Oracle Database SQL Language Reference.įor more information about the roles and the PLAN_TABLE, see the Oracle Database SQL Language Reference and the AUTOTRACE variable of the SET command. DBA privileges are required to grant the PLUSTRACE role. To use this feature, you must create a PLAN_TABLE table in your schema and then have the PLUSTRACE role granted to you. If STATISTICS is enabled, query data is still fetched, but not printed. Like SET AUTOTRACE ON, but suppresses the printing of the user's query output, if any.

The AUTOTRACE report includes both the optimizer execution path and the SQL statement execution statistics. The AUTOTRACE report shows only the SQL statement execution statistics. The AUTOTRACE report shows only the optimizer execution path.

Quest sql tuning for oracle