Ryan,
this is possibly soft parse count..have a check out of
asktom.oracle.com as there are some good examples on
there around this..
http://asktom.oracle.com/pls/ask/f?p=4950:8:12357749741999286880::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:2588723819082,
Regards,
Mark
- ryan.gaffuri_at_cox.net wrote: > timed statistics is
set to true. i checked.
> >
> > From: Michael Garfield Sørensen <mgs_at_CeDeT.dk>
> > Date: 2004/03/08 Mon PM 03:23:52 EST
> > To: <oracle-l_at_freelists.org>
> > Subject: SV: tkprof and parse count?
> >
> >
> > I personally think it just means that you did not
> have timed statistics
> > enabled! And thus the tracing wasn't able to
> report any timings!
> >
> > HTH
> > Michael Garfield Sørensen, CeDeT
> >
> > -----Oprindelig meddelelse-----
> > Fra: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] På
> > vegne af ryan.gaffuri_at_cox.net
> > Sendt: 8. marts 2004 20:50
> > Til: oracle-l_at_freelists.org
> > Emne: tkprof and parse count?
> >
> > Below is a simple tkprof output. Why is my parse
> count = 4? if there is no
> > CPU time used? I take this to mean, I did not
> incur a hard parse? How come
> > the 'count' goes up? I can't find this in the docs
> on metalink.
> >
> > select 2
> > from
> > dual
> >
> >
> > call count cpu elapsed disk
> query current
> > rows
> > ------- ------ -------- ---------- ----------
> ---------- ----------
> > ----------
> > Parse 4 0.00 0.00 0
> 0 0
> > 0
> > Execute 4 0.00 0.00 0
> 0 0
> > 0
> > Fetch 8 0.00 0.00 0
> 12 0
> > 4
> > ------- ------ -------- ---------- ----------
> ---------- ----------
> > ----------
> > total 16 0.00 0.00 0
> 12 0
> > 4
> >
> >
>
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> >
>
> > To unsubscribe send email to:
> oracle-l-request_at_freelists.org
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at
> http://www.freelists.org/archives/oracle-l/
> > FAQ is at
> http://www.freelists.org/help/fom-serve/cache/1.html
> >
>
> >
> >
>
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> >
>
> > To unsubscribe send email to:
> oracle-l-request_at_freelists.org
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at
> http://www.freelists.org/archives/oracle-l/
> > FAQ is at
> http://www.freelists.org/help/fom-serve/cache/1.html
> >
>
> >
>
>
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
>
> To unsubscribe send email to:
> oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at
> http://www.freelists.org/archives/oracle-l/
> FAQ is at
> http://www.freelists.org/help/fom-serve/cache/1.html
>
Find local movie times and trailers on Yahoo! Movies.
http://au.movies.yahoo.com
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Mon Mar 08 2004 - 14:45:09 CST