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