Oracle 8i standard vs enterprise edition
Petr Snajdr
snajdr na firma.seznam.cz
Úterý Květen 8 14:22:13 CEST 2001
On Tue, 8 May 2001, Honza Pazdziora wrote:
> On Tue, May 08, 2001 at 02:04:23PM +0200, Petr Snajdr wrote:
> > je nejaky duvod domnivat se, ze existuji nejake vykonostni
> > rozdily mezi Standard a Enterprise Edition v tom smyslu, ze
> > Enterprise Edition bz bzla pomalejsi v nekterych opaeracich?
> > Napr. 3 nasobny vnoreny join a to i v radech?
>
> Rozdil muze byt v jinych defaultnich nastavenich parametru u techto
> databazi, coz se muze projevit jinou vypocetni cestou (at uz
> v optimizeru, nebo i obecne vyuziti pameti, atp.). Je opravdu vsechno
> stejne, az na binarky toho serveru?
Prave ze neni, zatim mam k dispozici vice pocitacu a na kazdem
neco. Pozdej to zkusim poprehazovat. Takze ted se to lisi dokonce i v HW.
Nicmene zarazi me, ze treba takovyto dotaz (vyprodukovany kolegy)
SELECT * FROM (
SELECT spot_strategy, spot_create_date, spot_exclusive_in_pack,
campaign_client_id, spot_price, spot_total_imp , spot_per_day_imp,
spot_sale, spot_modify_user_id, spot_preference, spot_modify_date,
spot_id, campaign_status, spot_coef_holiday, spot_pack_id,
spot_create_user_id, spot_campaign_id , pack_name, spot_insist_on_end,
campaign_name, ROWNUM RNUM FROM (
SELECT spot.strategy AS spot_strategy , spot.create_date AS
spot_create_date, spot.exclusive_in_pack AS spot_exclusive_in_pack,
campaign.client_id AS campaign_client_id, spot.price AS
spot_price, spot.total_imp AS spot_total_imp,
spot.per_day_imp AS spot_per_day_imp, spot.sale AS spot_sale,
spot.modify_user_id AS spot_modify_user_id,
spot.preference AS spot_preference,
spot.modify_date AS spot_modify_date, spot.id AS spot_id,
campaign.status AS campaign_status, spot.coef_holiday AS
spot_coef_holiday, spot.pack_id AS spot_pack_id,
spot.create_user_id AS
spot_create_user_id,
spot.campaign_id AS spot_campaign_id , pack.name AS pack_name,
spot.insist_on_end AS spot_insist_on_end,
campaign.name AS campaign_name
FROM spot, pack, campaign WHERE spot.pack_id = pack.id AND
spot.campaign_id = campaign.id ORDER BY campaign.name asc)
) WHERE RNUM between 1 AND 10;
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.
Ted jsem se do toho teprve dal a 8.1.6 jsem pouzil proto, ze jsem
ji mel na CD (nez se stahne 8.1.7) z Internetu.
Konfigurace init.ora je dosti podobna (na SPARCu je vice
nadimenzovana, ale ne tak, aby to vedlo k swapovani,
natoz ze by se pretezoval jen jeden z procesoru) resp. v$parameter.
Na druhe strane v EE verzi jsou nektere veci udelat mnohem lepe a rychlej
nez v SE a to tak, ze proste jinak. To je duvod proc
to zkousim, ale ty vysledky dost dobre nechapu a na prvni pohled
mi neni zrejma chyba (resp. proc je ten rozdil tak velky) a jedina
vec, ktera me napdla jsou rozdily mezi SE a EE.
S pozdravem
Petr Snajdr
Další informace o konferenci Databases