Re: AUTOTRACE statistics

From: Venkat <vreddy_at_no_spamix.netcom.com>
Date: Fri, 10 Jul 1998 13:01:38 -0400
Message-ID: <6o5hc9$5vn@dfw-ixnews8.ix.netcom.com>

redo size is the amount of redo (bytes) that was generated for that statement (it can include redo for the statement and/or redo for data dictionary calls).
bytes sent via SQL*Net to/from client are the number of bytes that were transferred to or from the client and server sorts (memory) is the number of sorts (for example order by, group by etc) done in SGA. Ideally all sorts should be done in memory. sorts (disk) - when there is not enough memory available for sorts, the sorts are done on disk (temporary segments). One tuning goal is to reduce the number of sorts to disk

Venkat

>
>Statistics
>
>----------------------------------------------------------
> 0 recursive calls
> 2 db block gets
> 65481 consistent gets
> 315 physical reads
> 0 redo size
> 143 bytes sent via SQL*Net to client
> 228 bytes received via SQL*Net from client
> 3 SQL*Net roundtrips to/from client
> 0 sorts (memory)
> 0 sorts (disk)
>
>
>Could anyone tell me what do the last six statistics signify? Do they
>map to the information provided by SQL_TRACE.
>
>Thx.
>
>Umar Farooq
>umar.farooq_at_cressoft.com.pk
>
Received on Fri Jul 10 1998 - 12:01:38 CDT