shared memory error

From: Baker, Barbara <bbaker_at_denvernewspaperagency.com>
Date: Mon, 10 Dec 2001 14:23:45 -0800
Message-ID: <F001.003D958C.20011210141023@fatcity.com>

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). Received on Mon Dec 10 2001 - 16:23:45 CST