Previous | Table of Contents | Next

Page 146

Listing 8.19 Continued

        0  redo size
      726  bytes sent via SQL*Net to client
      376  bytes received via SQL*Net from client
        3  SQL*Net roundtrips to/from client
        0  sorts (memory)
        0  sorts (disk)
       14  rows processed
TIP
The TRACEONLY option is particularly useful when you are tuning a query that returns a large number of rows.

The client referred to in the execution statistics is SQL*Plus. SQL*Net refers to the generic interprocess communication between the client (SQL*Plus) and the server (Oracle RDBMS), whether SQL*Net is installed and used or not.

Previous | Table of Contents | Next