- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: oracle8.0.6 on hp11 K460
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-27-2002 02:04 PM
тАО03-27-2002 02:04 PM
oracle8.0.6 on hp11 K460
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-27-2002 02:08 PM
тАО03-27-2002 02:08 PM
Re: oracle8.0.6 on hp11 K460
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-27-2002 02:12 PM
тАО03-27-2002 02:12 PM
Re: oracle8.0.6 on hp11 K460
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-27-2002 04:04 PM
тАО03-27-2002 04:04 PM
Re: oracle8.0.6 on hp11 K460
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-27-2002 06:12 PM
тАО03-27-2002 06:12 PM
Re: oracle8.0.6 on hp11 K460
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.