rp7410/20 Oracle performance

[David DiBiase]

Does anyone know if performance measurements have been done between Oracle 9i and 10g on HP RP class machines?

[Steven E. Protter · Accepted solution]

Shalom,

The performance on of 10g on every platform I've run it on is better than 9i any release. The improvement in how the database manages its own performance is reasonable.

There still is work to be done from the systems administration area, and all pre-requisite OS patches must be installed prior to installing the Oracle software. Kernel parameters need to be tuned to deal with how the database uses resources.

Attention needs to be paid to properly laying out I/O so there are no hot spots or bottlenecks.

SEP

[David DiBiase]

SEP,

Thanks for your reply. That is what I have found so far. The tuning effort has been a lot of trial and error so far.

[Steven E. Protter]

Shalom again,

There is little people can do except offer advice and help.

How the application that reads the data is written is of critical importance. Bad sql code will ruin the work of even the best sysadmins.

Advice:
11.11 Reduce the buffer cache.
dbc_max_pct in the 5-10 range, dbc_min_pct no more than 5-10 lower. Changing the buffer cache on the fly has a bad impact on performance.

Document UPERFKBAN00000726 in the technical knowledgebase, which has been rudely moved again and I can't find a url.

http://docs.hp.com/en/1219/tuningwp.html

SEP

[Yogeeraj_1]

hi,

Did you search the TPC and TPC-c or "performance" organisations?

Why do you need these information? If you need it for your own use. It would be preferable that you do your own tests because your environment is most probably a unique one.

Overall, there is definitely a performance gain in terms of the Database software itself being more robust with the "self-healing" features. 10g already includes the bug fixes on 9i.

The resource requirements is yet another issue. Anybody can predict 10g being more resource hungry than 9i and that 11g will be more resource hungry than 10g...

hope this helps!

kind regards
yogeeraj