I am still on Oracle 7.2.3 on HP3000 mpe/ix waiting for Oracle 7.3
I
     am ready to put Oracle back in the box and burn it.

     Specifically waiting for SQL*Net Tuning on the Server limitations
of
     2k.

     Replication in a more stable environment.



     Also, has anybody implemented Oracle's new Developer/2000 for the
Web.
     I put up an application server on nt 4.0
         - 2 segments
         - 1 for sql net directly to the hp
         - 1 for http connects via internal network and internet
     running MS Internet Service
     running developer/2000 1.5
     copied over my forms
     used java 1.1 appletviewer
     i am receiving good response from my LAN
     nasty response over my private wan and the internet

     looks like it is a forms presentation problem.
     told by Oracle we would receive the same response on the wan as the

     lan.

     NOT !!!!!! ready to burn that one too !!!!!!


     David Hutchinson
     Gerber Garment Tech
     24 Industrial Park Road West
     Tolland CT 06084
     860.871.3841



______________________________ Reply Separator
_________________________________
Subject: oracle partion views - they don't work!
Author:  ,[log in to unmask] [SMTP:[log in to unmask]] at Exchange_Hub
Date:    9/29/97 10:42 AM


Have a datamart (star scema) about 4M rows in the fact.  Performance
sucked, so I broke it into 8 tables and partioned viewed.  they SUCK!

I turned the ora.init parameter on.
I constraied each table on the first part of the prim key. (time).
I created a union all view.
Oracle 7.3 HP 1 GB ram and 2 processors

I then ran a query and - no matter the where clause it will hit every
table.  Even if I say where time_key = 3.  No matter what.  If the
elimination of tables dosen't work then the benefits of severly
minimined.
True this will allow me to scan the table quicker (8x).   But i need
more!

I'm running redbrick on the same box - ported the datamart over in 2
hours.  Redbrick kicks the crap out of oracle.  Maybe oracle is not
ready
for warehousing! - I'm going to oracle 8 soon any body know if oracle 8
is
any better.

I'm about to put oracle back in the box and burn it.

I appreciate comments from anyone who has had partion view work to
eliminate tables! or actually built a 'REAL' datamart in oracle and had
oracles star execution path kick in w/o hints and had it return a result

set in a reasonable time frame (< 15 secs).

Thanks for any comments / knowledge!
Dave.
[log in to unmask]

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet