IGNORE: shared memory error

Oops!
Pasted to the wrong window.
So sorry.
Barb

> ----------
> From: Baker, Barbara
> Sent: Monday, December 10, 2001 3:12 PM
> To: 'ORACLE-L_at_fatcity.com'
> Subject: shared memory error
>
> Paula:
> This is pretty ugly. Let's at least see if we can get rid of the
> cartesian.
> Barb
>
>
> ----------------------------------------------------------
> 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=293 Card=2587 Bytes=
> 724360)
> 1 0 SORT (UNIQUE) (Cost=293 Card=2587 Bytes=724360)
> 2 1 UNION-ALL
> 3 2 NESTED LOOPS (Cost=109 Card=1679 Bytes=470120)
> 4 3 NESTED LOOPS (Cost=14140 Card=1083 Bytes=251256)
> 5 4 HASH JOIN (Cost=60676 Card=282793 Bytes=53447877)
> 6 5 TABLE ACCESS (FULL) OF 'AD' (Cost=192 Card=62123
> Bytes=6212300)
> 7 5 MERGE JOIN (CARTESIAN) (Cost=39673 Card=2771559
> Bytes=246668751)
> 8 7 TABLE ACCESS (FULL) OF 'SALESPERSON' (Cost=1
> Card=261 Bytes=8874)
> 9 7 SORT (JOIN) (Cost=39672 Card=10619 Bytes=584045)
> 10 9 TABLE ACCESS (FULL) OF 'INVROWS' (Cost=152
> Card=10619 Bytes=584045)
> 11 4 TABLE ACCESS (BY INDEX ROWID) OF 'CUSTOMER' (Cost=1
> Card=412032 Bytes=17717376)
> 12 11 INDEX (UNIQUE SCAN) OF 'I_CUS1' (UNIQUE)
> 13 3 TABLE ACCESS (BY INDEX ROWID) OF 'PUB' (Cost=1
> Card=96304 Bytes=4622592)
> 14 13 INDEX (RANGE SCAN) OF 'I_PUB1' (UNIQUE) (Cost=1
> Card=96304)
> 15 2 NESTED LOOPS (Cost=76 Card=908 Bytes=254240)
> 16 15 NESTED LOOPS (Cost=218768391 Card=752 Bytes=174464)
> 17 16 MERGE JOIN (Cost=101449 Card=4375367808
> Bytes=577548550656)
> 18 17 SORT (JOIN) (Cost=97464 Card=2771559
> Bytes=246668751)
> 19 18 MERGE JOIN (CARTESIAN) (Cost=39673 Card=2771559
> Bytes=246668751)
> 20 19 TABLE ACCESS (FULL) OF 'SALESPERSON' (Cost=1
> Card=261 Bytes=8874)
> 21 19 SORT (JOIN) (Cost=39672 Card=10619 Bytes=584045)
> 22 21 TABLE ACCESS (FULL) OF 'INVROWS' (Cost=152
> Card=10619 Bytes=584045)
> 23 17 SORT (JOIN) (Cost=3985 Card=412032 Bytes=17717376)
> 24 23 TABLE ACCESS (FULL) OF 'CUSTOMER' (Cost=945
> Card=412032 Bytes=17717376)
> 25 16 TABLE ACCESS (BY INDEX ROWID) OF 'AD' (Cost=1
> Card=525111 Bytes=52511100)
> 26 25 INDEX (UNIQUE SCAN) OF 'I_AD1' (UNIQUE)
> 27 15 TABLE ACCESS (BY INDEX ROWID) OF 'PUB' (Cost=1
> Card=633898 Bytes=30427104)
> 28 27 INDEX (RANGE SCAN) OF 'I_PUB1' (UNIQUE) (Cost=1
> Card=633898)
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Baker, Barbara
  INET: bbaker_at_denvernewspaperagency.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).