- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle slow.
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
Forums
Discussions
Discussions
Discussions
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
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
04-16-2001 10:40 AM
04-16-2001 10:40 AM
Oracle slow.
My HPUX 11.0 system has enough CPU idle time, but clients are complaining that a simple read of oracle from a table and write to a table is taking a very long time to complete. I suspect memory and memory kernel params. Any assistance would be appreciated.
Thanks.
Atul Thakur
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-16-2001 10:47 AM
04-16-2001 10:47 AM
Re: Oracle slow.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-16-2001 12:39 PM
04-16-2001 12:39 PM
Re: Oracle slow.
Otherwise, you may want to rebuild the index to that table if there is one.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-16-2001 12:40 PM
04-16-2001 12:40 PM
Re: Oracle slow.
If this all looks good, then I would check Oracle statistics to see if the SGA is too small.
Next I would check on the OS side is the disk configuration. It is the most likely cause of sluggish performance. Are you using RAID? Are your tablespaces spread across separate LUNs or physical disks? You can use glance or sar -d for a quick look at disk performance.
If all this looks good, then check further into the OS, kernel parameters.. paging... etc..
Regards,
Tim
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-16-2001 10:56 PM
04-16-2001 10:56 PM
Re: Oracle slow.
general in thos questions it would be good to have some more information:
- size of the db
- size of database buffer cache (db_blockbuffers, db_block_size)
- SQL-Satement causing trouble (if available)
- physical memeory in box
General aproach:
- If this is a plain DB server, decrease UX-kernel-params for filesystem cache, to prevent swaps of the db-buffer. Be sure, that the DB-Buffer fits into phys mem all the time.
- Is the situation from start, or has anything changed -> This might even be application side, like dataloads, new module is live now or so.-> Hunt the changes.
- Entire system or specific action:
Entire System -> go for buffers, locks, io-times in general
Specific action -> which statement ? Can it be re-written or indexsupported ?
Hope this helps a bit
Volker
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-16-2001 10:56 PM
04-16-2001 10:56 PM
Re: Oracle slow.
general in thos questions it would be good to have some more information:
- size of the db
- size of database buffer cache (db_blockbuffers, db_block_size)
- SQL-Satement causing trouble (if available)
- physical memeory in box
General aproach:
- If this is a plain DB server, decrease UX-kernel-params for filesystem cache, to prevent swaps of the db-buffer. Be sure, that the DB-Buffer fits into phys mem all the time.
- Is the situation from start, or has anything changed -> This might even be application side, like dataloads, new module is live now or so.-> Hunt the changes.
- Entire system or specific action:
Entire System -> go for buffers, locks, io-times in general
Specific action -> which statement ? Can it be re-written or indexsupported ?
Hope this helps a bit
Volker
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-17-2001 12:26 AM
04-17-2001 12:26 AM
Re: Oracle slow.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-17-2001 12:57 AM
04-17-2001 12:57 AM
Re: Oracle slow.
You should use glance to check your overall performance. It will give you metrics on network, memmory, disk, swap, kernel, ...
If you don't have it installed, you can install a trial version from the application CDs.
After this, you should check your kernel parameters and optimize them.
dbc_max_pct should be ~10
dbc_min_pct ~6
bufpages 0
nbuf 0
plus, pay attention to shmmax, semmni, semmns.
check this doc for general kernel information:
http://docs.hp.com/hpux/content/KCparams.OverviewAll.html
good luck.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-17-2001 05:49 AM
04-17-2001 05:49 AM
Re: Oracle slow.
This may also depend on the network.
Another step may be to separate the files on different disks with ( if possible ) different controler. You can put the breaks on your database, when you have logfiles, offline logfiles and tablespaces on the same physical disk. Try to put logfile on one disk, control files on a second, tablespaces for tables on a third, tablespaces for indexes on a fourth, but only if possible. Also the optimizer mode
can be responsible for the speed.
Perhaps you can put the init.ora and the filelist as an attachment to this place.
Rgds
Alexander M. Ermes