Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: tkprof: who can help to understand

Re: tkprof: who can help to understand

From: <zyman_at_my-deja.com>
Date: Mon, 25 Sep 2000 14:23:08 GMT
Message-ID: <8qnn3k$hhu$1@nnrp1.deja.com>

Ok.
Thank You.

In article <8qgjrm$ujc$1_at_nnrp1.deja.com>,   oratune_at_aol.com wrote:
> In article <8qgeq9$o94$1_at_nnrp1.deja.com>,
> zyman_at_my-deja.com wrote:
> > Hi
> > I got this from tkprof.
> >
> > select sb.*
> > from
> > pirweb.sched_bulletins sb
> > where
> > (sb.bulletin_no in (select distinct(bb.bulletin_no)
> > from pirweb.bts_bulletin_v bb))
> > or
> > (sb.bulletin_no in (select distinct(bp.bulletin_no)
> > from pirweb.bts_promo_v bp ))
> >
> > call count cpu elapsed disk query current rows ------- --



> > -------- ---------- ---------- ---------- ---------- ----------
 Parse
 1
> > 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0
 Fetch 3 0.00
> > 0.00 142630 143706 13740 1031 ------- ------ --------


> > ---------- ---------- ---------- ---------- total 5 0.00 0.00
 142630
> > 143706 13740 1031
> >
> > Misses in library cache during parse: 1
> > Optimizer goal: CHOOSE
> > Parsing user id: 30 (PIRWEB)
> >
> > Rows Execution Plan -------
> > --------------------------------------------------- 0 SELECT
 STATEMENT
> > GOAL: CHOOSE 0 FILTER 0 TABLE ACCESS (FULL) OF 'SCHED_BULLETINS'
 0
> > TABLE ACCESS (FULL) OF 'ALL_BULLETINS' 0 TABLE ACCESS (FULL)
 OF
> > 'ALL_BULLETINS'
> >

>

> *****
> > ***
> >
> > OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS
> >
> > call count cpu elapsed disk query current rows ------- --


> > -------- ---------- ---------- ---------- ---------- ----------
 Parse
 1
> > 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0
 Fetch 3 0.00
> > 0.00 142630 143706 13740 1031 ------- ------ --------


> > ---------- ---------- ---------- ---------- total 6 0.00 0.00
 142630
> > 143706 13740 1031
> >
> > Misses in library cache during parse: 1
> > Misses in library cache during execute: 1
> >
> > The question is : why I have such interesting numbers in COUNT
 column
 1-2-3 ?
> > as i understand this is not a steps of execution but "number of
 times
> > statement was parsed...." I just don't understand how it can be
 fetched 3
> > times..... Thank You.
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>

> One query containing two subqueries equals 3 queries, which equates to
> 3 fetches.
>

> --
> David Fitzjarrell
> Oracle Certified DBA
>

> Sent via Deja.com http://www.deja.com/
> Before you buy.

>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Sep 25 2000 - 09:23:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US