- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Disk utilization on 9i oracle.
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
тАО04-06-2005 05:59 AM
тАО04-06-2005 05:59 AM
Re: Disk utilization on 9i oracle.
"Depending on the number of datafiles in a database, a checkpoint can be a
highly resource intensive operation, since all datafile headers are frozen
during the checkpoint. There is a performance trade-off regarding frequency
of checkpoints. "
cf. Metalink doc id 147468.1
what value do you have for (oracle parameters) :
- CHECKPOINT_PROCESS
- LOG_CHECKPOINT_INTERVAL
- LOG_CHECKPOINT_TIMEOUT
- LOG_CHECKPOINTS_TO_ALERT
Regards
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-06-2005 06:33 AM
тАО04-06-2005 06:33 AM
Re: Disk utilization on 9i oracle.
as you are running Oracle with EVA backend storage you may want to read this doc
http://h71028.www7.hp.com/ERC/downloads/5983-0322EN.pdf
Regards
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-06-2005 06:37 AM
тАО04-06-2005 06:37 AM
Re: Disk utilization on 9i oracle.
If you're scsi_max_qdepth is 8 or 16, increase it to 32 or even 64 since you are using few LUNs.
scsi_max_qdepth is a dynamic kernel tunable so you need not reboot your box.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-06-2005 06:41 AM
тАО04-06-2005 06:41 AM
Re: Disk utilization on 9i oracle.
Thanks again for all responses!!!
Charlie
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-06-2005 06:45 AM
тАО04-06-2005 06:45 AM
Re: Disk utilization on 9i oracle.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-06-2005 07:39 AM
тАО04-06-2005 07:39 AM
Re: Disk utilization on 9i oracle.
- LOG_CHECKPOINT_INTERVAL 100000
- LOG_CHECKPOINT_TIMEOUT 1200
- LOG_CHECKPOINTS_TO_ALERT TRUE
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-06-2005 07:42 AM
тАО04-06-2005 07:42 AM
Re: Disk utilization on 9i oracle.
That explains your queuing and evidently slow performance your app is draining from your EVA. I suppose your lone filesystem is also on just one big EVA LUN or a couple of big EVA LUNs. You really need to bump this value up.
How many environments are hooked up to your EVA? If it has say 8 servers hooked up and each has dual paths.. I can safely recommend bumping up your current 8 to 32 on this server where you are having a problem.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-06-2005 07:45 AM
тАО04-06-2005 07:45 AM
Re: Disk utilization on 9i oracle.
Think I should go higher say 64?
Thanks
Charlie
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-06-2005 08:12 AM
тАО04-06-2005 08:12 AM
Re: Disk utilization on 9i oracle.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-06-2005 08:28 PM
тАО04-06-2005 08:28 PM
Re: Disk utilization on 9i oracle.
I have a SureStore E Disk Sys SC10 Factory Rack.
Here are my stats:
09:10:09 device %busy avque r+w/s blks/s avwait avserv
Average c4t8d0 9.67 0.53 14 416 4.94 9.59
Average c4t9d0 6.23 0.50 9 143 5.11 7.83
Average c5t8d0 6.43 0.54 9 329 4.95 11.08
Average c5t9d0 2.03 0.50 2 40 4.93 11.12
Average c1t2d0 1.30 0.50 2 18 3.17 12.23
Average c2t2d0 0.58 0.50 1 14 3.43 7.96
Charles:
You may want to try to decrease your LOG_CHECKPOINT_INTERVAL to 20000, increase the LOG_CHECKPOINT_TIMEOUT to 3600 and switch off LOG_CHECKPOINT_TO_ALERT. Another parameter that influences the checkpoint process is FAST_START_MTTR_TARGET: what is your value for this parameter??
Best Regards,
Eric
- « Previous
- Next »