Re: meaning of "query" column

On Mar 15, 4:10 pm, "Ed" <e..._at_mail.com> wrote:
> What does "query" column mean ?
> thanks
>
> call count cpu elapsed disk
> query current rows
> ------- ------ -------- ---------- ---------- ----------
> ---------- ----------
> Parse 1 0.00 0.00 0
> 0 0 0
> Execute 1 0.01 0.02 0
> 78 8 2
> Fetch 0 0.00 0.00 0
> 0 0 0
> ------- ------ -------- ---------- ---------- ---------- ---------- ----------
> total 2 0.01 0.02 0 78 8
> 2
>
> Misses in library cache during parse: 1
> Misses in library cache during execute: 1
> Optimizer goal: ALL_ROWS
> Parsing user id: 257 (recursive depth: 2)
>
> 10gR2

Context TFPROF?

"QUERY: Total number of buffers retrieved in consistent mode for all parse, execute, or fetch calls. Usually, buffers are retrieved in consistent mode for queries."
  http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14211/sqltrace.htm

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Thu Mar 15 2007 - 15:34:17 CDT