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.
Received on Fri Sep 22 2000 - 16:44:27 CDT