oracle8.0.6 on hp11 K460

[Erik Allaert]

Hola,

I have an Oracle server running on a HP K460 (4cpu 1Gb mem) and its running sloooowly. I have a feeling it could be kernel settings. Does anybody have an idea?

How does one enhance the perfermance of Oracle server?

Thanks


Ean

[Sridhar Bhaskarla]

Hola,

From the Server Operations perspective, you can always look at different things. One common thing that affects oracle's performance from the system's view is disk I/O. Look at the following document for tools and tuning.

http://us-support3.external.hp.com/cki/bin/doc.pl/sid=eeee98dc0d66c1ac32/screen=ckiDisplayDocument?docId=200000058668844

-Sri

[A. Clay Stephenson]

Hi:

First of all, 1GB is a very small amount of RAM to be running a database and especially if it's 64-bit Oracle. Secondly, check the value of timeslice; if you used the OLTP tuned parameter set, it sets the value to 1 rather than 10 and that will kill performance. If your dbc_max_pct is set to the default 50 drop it to no more than about 15 with min_dbc_pct set to about 5 (or better still use bufpages to set a static cache).

Other than that, without data (like the output from kmtune, sysdef, vmstat, sar) there is no way to help you. I can say that I have 8.0.6.2.0 running on 2 K-boxes and it performs quite well.

You really need to use a tool like Glance to identify the bottlenecks before you can proceed. Now having said all of this - the most likely cause of your poor performance is bad SQL code.

[Sanjay_6]

Hi Ean,

Try the OLTP / Database Server system tuned kernel parameter set using sam -> Kernel Configuration --> Configurable Kernel Parameters --> Action --> Add Tuned Set , select OLTP /Datbase server system. Rebuild the kernel, reboot the system and then check the system for perfomance.

Hope this helps.

Regds

[Printaporn_1]

Hi,

If you get I/O problem
- distribute datafiles/index files
- Arrange redo log
- mount filesystem with mincache=direct
- tune db_file_multiblock_read_count in init.ota
if you still have plenty of memory unused
but Oracle Slow

- increase SGA in init.ora by increase
shared_pool_size, db_block_buffer

there are many monitoring oracle view to tune the performance , please start by Oracle performance tuning manual , to see what can be real bottleneck.