- Community Home
- >
- Servers and Operating Systems
- >
- HPE ProLiant
- >
- ProLiant Servers (ML,DL,SL)
- >
- Oracle config performance
ProLiant Servers (ML,DL,SL)
1753556
Members
5916
Online
108796
Solutions
Forums
Categories
Company
Local Language
back
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Discussions
back
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
Blogs
Information
Community
Resources
Community Language
Language
Forums
Blogs
Topic Options
- 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
06-25-2008 10:06 AM
06-25-2008 10:06 AM
Oracle config performance
I am currently at a site that is having Oracle disk i/o performance issue. The current config is a DL380 G4 (3 years old) with 6 146GB 10k RPM scsi disks in a raid 5 array.
The array has 2 partitions. 1st partition has the OS (Server 2003) install. The second partition has the Oracle install, Oracle DB, Oracle transaction logs, and a application called Costpoint. This application is what the database is mainly for. However, there are several other apps on other machines and Integrated Web Reports that access this database.
A few months back user and application guys reported the system is slow. This was the same time another application and more users started accessing this data. We have no issues with CPU, memory or network utilization. Oracle STATPAK reports some slow disk i/o.
The system is supposed to be replaced and software upgraded late in Q4. They want some immediate solutions. I am recommending a rebuild.
2 x 146GB Raid 1 - OS, Oracle install, Costpoint app install and Oracle transaction logs
4 x 146 Raid 1 - Oracle database
Does anyone out there have experience or can give me an estimate of what performance increase this might give. Is it worth doing to help us out until a new server can be installed? Any other config recommended?
Jeff
The array has 2 partitions. 1st partition has the OS (Server 2003) install. The second partition has the Oracle install, Oracle DB, Oracle transaction logs, and a application called Costpoint. This application is what the database is mainly for. However, there are several other apps on other machines and Integrated Web Reports that access this database.
A few months back user and application guys reported the system is slow. This was the same time another application and more users started accessing this data. We have no issues with CPU, memory or network utilization. Oracle STATPAK reports some slow disk i/o.
The system is supposed to be replaced and software upgraded late in Q4. They want some immediate solutions. I am recommending a rebuild.
2 x 146GB Raid 1 - OS, Oracle install, Costpoint app install and Oracle transaction logs
4 x 146 Raid 1 - Oracle database
Does anyone out there have experience or can give me an estimate of what performance increase this might give. Is it worth doing to help us out until a new server can be installed? Any other config recommended?
Jeff
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.
News and Events
Support
© Copyright 2024 Hewlett Packard Enterprise Development LP