Re: O8i & O9i, which one is more faster?

Bin,

Did you gather stats for the 9i installation? Oracle highly recommends doing this with Oracle 9i with a new built in procedure. Here is a script I use to gather the stats:
http://www.dotcomsolutionsinc.net/products/installgen/win_901_32bit_files/in stallgen_win901_59_.html

And here is the script which uses the stats: http://www.dotcomsolutionsinc.net/products/installgen/win_901_32bit_files/in stallgen_win901_57_.html

Additionally, here is a script which gathers schema stats (this is in addition to the overall system stats gathered above): http://www.dotcomsolutionsinc.net/products/installgen/win_901_32bit_files/in stallgen_win901_56_.html

You can download all of the scripts here: http://www.dotcomsolutionsinc.net/downloads/demo_software/index.html

David Simpson
www.dotcomsolutionsinc.net

"ZhangBin" <zhangb_at_public.bta.net.cn> wrote in message news:advnfk$gd4$1_at_info.bta.net.cn...
> Hello, every body:
>
> I made a test with the following functions for both Oracle 8i and Oracle
 9i
> on a same machine, the test progress is take operation to all 10000
 records,
> the final result is:
>
> Function 8i 9i
> Insert 45195ms 68409ms
> Select 9274ms 13480ms
>
> Who can tell me why the Oracle 8i is faster than the 9i? As a natural
> understanding, the 9i should be more faster than 8i.
>
> The following is my test environment.
> Server: Win2K + SP2, and reinstall the entire system after one test.
> Client: Win2K + SP2, and reinstall the entire system after one test.
>
> Thanks!!!
> Bin
>
>
>
>
>
>
Received on Sun Jun 09 2002 - 16:36:11 CEST