Re: AUTOTRACE statistics

From: Winnie Liu <poohland_at_hotmail.com>
Date: Sat, 11 Jul 1998 07:51:58 -0700
Message-ID: <6o7tum$qcf@sjx-ixn10.ix.netcom.com>

I am not very sure. But isn't the Autotrace in SQL Plus will only trace the information of your own session instead of the whole system?

Winnie

Umar FArooq wrote in message <35A5ED65.11508501_at_cressoft.com.pk>...
>Hi!
>The following are statistics from SQL Plus's AUTOTRACE:
>
>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 Sat Jul 11 1998 - 09:51:58 CDT