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