- 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
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-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
-
- 1
- 2
- Next »