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