AutoTrace Statistics

[gokden]

Guys, I was kind of studying how to improve the consultations with hints
Ai appeared this:

Select all

Statistics 
--------------------------------------------------- 
          0  recursive calls 
          0  db block gets 
       4598  consistent gets 
          0  physical reads 
          0  redo size 
   25246689  bytes sent via SQL*Net to client 
      44503  bytes received via SQL*Net from client 
       4017  SQL*Net roundtrips to/from client 
          2  sorts (memory) 
          0  sorts (disk) 
      60239  rows processed

So far nothing wrong, but someone knows what each item This means ??
And even have any improvement using HINTS ??
PS: the only item qui I intendi there is the rows processed = d poor bench = x

[dr_gori]

There goes: http://docs.oracle.com/cd/B10500_01/ser ... totrac.htm
Recursive Calls
Number of recursive calls generated at Both The User and System Level. Oracle Maintains Tables Used for Internal Processing. When Oracle Needs to make the Change to These Tables, IT Internally Generates An Internal SQL Statement, Which In Turn Generates to Recursive Call.

DB Block gets [
Number of times a Current Block WAS requests.

Consistent Gets
Number of Times A Consistent Read WAS Requested for Block.

Physical Reads
Total Number of Data Blocks Read from Disk. This Number Equals The Value of "Physical Reads Direct" Plus All Reads Into Buffer Cache.

Redo Size
Total Amount of Rede Generated In bytes.

Bytes Sent via SQL * net to client
Total number of bytes Sent to the client from the foreground Processes.

Received bytes via SQL * net from client
Total number of bytes received from the client Over Oracle Net.

] sql * net roundtrips to / from client
Total Number of Oracle Net Messages Sent to and received from the client.

Sorts (Memory)
Number of Sort Operations That Were Performed Completely In Memory and Did Not Required Any Disk Writes.

SORTS (DISK)
Number of Sort Operations That Required at Least One Disk Write.

rows processed
Number of Rows Processed During the Operation.