Re: Oracle v7.3.2 Benchmark Tests

Hi,

Make shure you have run the analyze table estimate/compute statistics. I am shure you did this.
Make shure you have the compatible parameter up to 7.3.2 not just 7.3. Maybe Oracle expert will give you a good hint ? open cursors, sort area size ..

I 'd be very interested in this benchmarks for different platforms. If it's not too much work i will run it on a 2CPU PowerChallenge R10000 and/or a IBM RS6000 580H.

Good luck,

Toni
In article <Pine.3.94.961112162736.26965C-100000_at_nddba1>, Darren Darnell <dba0077_at_edwardjones.com> wrote:

> The following is a comparison of the execution time (in seconds) of 10
> different benchmark tests. The test were performed on a V7.14 and a v7.3.2
> database. The databases are identical, except for upgrading database objects.
> The v7.1.4 datafiles and parameter files were copied to different directories
> on the same system and same devices for the v7.3.2 database.
>
> Does anyone have any ideas why v7.3.2 does not perform as well as v7.1.4?
> I have tried changing several of the initialization paramters
> (COMPATIBILITY, SORT_DIRECT_WRITES), and none have changed the perfomance.
> In fact setting SORT_DIRECT_WRITES to FALSE made matters worse.
>
> Summary of statments in benchmark tests:
 

-- 
A. Dischner, SGI&AIX sysadmin, Oracle DBA       | Don't let friends
Institut fuer Klinische Chemie                  | use WinDose
Klinikum Grosshadern                            | Just say NO. 
Ludwig Maximilians Universitaet Muenchen,  GER  |            
Marchioninistr.15 81366 Muenchen 49-89-70953202 |