Oracle 8i standard vs enterprise edition

Petr Snajdr snajdr na firma.seznam.cz
Úterý Květen 8 15:17:50 CEST 2001


> > trva na SPARC e420/2xCPU 450 MHz,2 GB RAM,  8i 8.1.7 EE asi _10x_ dele nez
> > na PC/Linux/500 MB RAM, Pentium II/500 8i 8.1.6 SE. 
> 
> Co o tom rika explain na jedne a na druhe platforme? Nedela tam
> optimizer neco vylozene skodliveho? Resp. jsou ty vypocetni plany
> stejne?


zda se, ze ... asi takto:

8.1.7 EE/Sparc/Solaris

Execution Plan
----------------------------------------------------------
   0      SELECT STATEMENT Optimizer=CHOOSE
   1    0   VIEW
   2    1     COUNT
   3    2       VIEW
   4    3         SORT (ORDER BY)
   5    4           NESTED LOOPS
   6    5             NESTED LOOPS
   7    6               TABLE ACCESS (FULL) OF 'CAMPAIGN'
   8    6               TABLE ACCESS (BY INDEX ROWID) OF 'SPOT'
   9    8                 INDEX (RANGE SCAN) OF 'IDX_SPOT_CAMPAIGN_ID'
           (NON-UNIQUE)

  10    5             TABLE ACCESS (BY INDEX ROWID) OF 'PACK'
  11   10               INDEX (UNIQUE SCAN) OF 'PACK_PK_ID' (UNIQUE)



8.1.6 SE/Intel/Linux

Execution Plan
----------------------------------------------------------
   0      SELECT STATEMENT Optimizer=CHOOSE (Cost=472 Card=6238 Bytes=
          1915066)

   1    0   VIEW (Cost=472 Card=6238 Bytes=1915066)
   2    1     COUNT
   3    2       VIEW (Cost=472 Card=6238 Bytes=1833972)
   4    3         SORT (ORDER BY) (Cost=472 Card=6238 Bytes=555182)
   5    4           HASH JOIN (Cost=118 Card=6238 Bytes=555182)
   6    5             TABLE ACCESS (FULL) OF 'PACK' (Cost=1 Card=275 B
          ytes=4400)

   7    5             HASH JOIN (Cost=101 Card=6238 Bytes=455374)
   8    7               TABLE ACCESS (FULL) OF 'CAMPAIGN' (Cost=5 Card
          =1822 Bytes=47372)

   9    7               TABLE ACCESS (FULL) OF 'SPOT' (Cost=10 Card=62
          38 Bytes=293186)

> Ja bych si tipnul na nejaky rozdil mezi temi verzemi (8.1.6 a 8.1.7),
> kde se treba zmenilo defaultni chovani neceho, takze bude nutne trosku
> ladit.

Jo, zda se. Ted mi sice neni uplne zrejme co s tim, ale to uz vypada jako
data z nichz se da vyjit :-)

S pozdravem
   petr Snajdr



Další informace o konferenci Databases