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.