Oracle 8i standard vs enterprise edition

[Petr Snajdr]

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