Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
cancel
Showing results for 
Search instead for 
Did you mean: 

oracle8.0.6 on hp11 K460

Erik Allaert
Occasional Advisor

oracle8.0.6 on hp11 K460

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
4 REPLIES
Sridhar Bhaskarla
Honored Contributor

Re: oracle8.0.6 on hp11 K460

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

You may be disappointed if you fail, but you are doomed if you don't try
A. Clay Stephenson
Acclaimed Contributor

Re: oracle8.0.6 on hp11 K460

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.
If it ain't broke, I can fix that.
Sanjay_6
Honored Contributor

Re: oracle8.0.6 on hp11 K460

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
Esteemed Contributor

Re: oracle8.0.6 on hp11 K460

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.
enjoy any little thing in my life