| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: shared memory error
Maybe you should enter it in Eric P.'s ugly SQL contest?
Jared
"Baker, Barbara"
<bbaker_at_denvernewspapera To: Multiple recipients of list
ORACLE-L <ORACLE-L_at_fatcity.com>
gency.com> cc:
Sent by: Subject: shared memory error
root_at_fatcity.com
12/10/01 02:10 PM
Please respond to
ORACLE-L
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=1Card=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-LReceived on Mon Dec 10 2001 - 18:06:52 CST
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: Jared.Still_at_radisys.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).
 |
 |