- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Configuring Disk for database
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
тАО06-14-2004 05:25 AM
тАО06-14-2004 05:25 AM
Configuring Disk for database
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-14-2004 05:33 AM
тАО06-14-2004 05:33 AM
Re: Configuring Disk for database
index and data raid 1
rollback raid 10.
Other files can be raid 5.
If you are going to stripe anyway the more disks the better.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-14-2004 05:39 AM
тАО06-14-2004 05:39 AM
Re: Configuring Disk for database
I do not agreee on this one :
data and index on RAID5
redo, undo on RAID1
data and indexes are accessed rather randomly, where redo and undo are accessed sequentially.
Regards,
Fred
"Reality is just a point of view." (P. K. D.)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-14-2004 06:12 AM
тАО06-14-2004 06:12 AM
Re: Configuring Disk for database
Since the indexes are usually quite small when compared to the table spaces you wouldn't of course set up a 4-LUN striped volume just for indexes. The alternative is of course putting indexes on a single LUN. We usually put our indexes on the same LUNs as our table spaces as we believe we get better performance by striping those as you stated (instead of putting indexes on a single disk).
To be honest however, we have not actually tested performance differences between putting the indexes on a single, separate LUN over including them in the striped data volume group. I must get around to that one of these days.
The more important thing is to try and keep the redo/undo logs off table space disks.
David
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-14-2004 06:47 AM
тАО06-14-2004 06:47 AM
Re: Configuring Disk for database
Data and indexes can be put on the same VG with stripping without affecting performances (whereas puting redo logs on RAID 1 improves it a lot).
But saying indexes are rather small compared to data is not so right. On common OLTP DBs, what can be observed is a ratio of 1:1 between indexes and databases.
Regards,
Fred
"Reality is just a point of view." (P. K. D.)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-14-2004 07:14 AM
тАО06-14-2004 07:14 AM
Re: Configuring Disk for database
(Stripe And Mirror Everything)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-14-2004 07:17 AM
тАО06-14-2004 07:17 AM
Re: Configuring Disk for database
Maybe on 10g, but I'am actually setting up some machines on a SAN with multiple Oracle DBs, and making RAID1 LUNs for logs, undo and temp really helped.
Regards,
Fred
"Reality is just a point of view." (P. K. D.)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-14-2004 07:20 AM
тАО06-14-2004 07:20 AM
Re: Configuring Disk for database
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=30286.1
Regards,
Fred
"Reality is just a point of view." (P. K. D.)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-14-2004 07:22 AM
тАО06-14-2004 07:22 AM
Re: Configuring Disk for database
In my opinion, you would be best to stripe what you got...if you have time, you could set it up with separate disks - benchmark, then set it up with striping, benchmark again and compare the results..
Here's a standard I tend to follow:
/app/oracle - .5GB to 1GB - oracle userid home
/app/oracle/product - 2GB to 4GB - oracle software installation
/data/oracle - .5GB to 1GB - miscellaneous storage
/data/oracle/xxxx - .5GB to 1GB - miscellaneous storage
/data/oracle/xxxx/datayy - data volumes for tablespaces - generally 2GB to 8GB - xxxx is the Oracle instance name, yy is volume number
/data/oracle/xxxx/indxzz - index volumes for tablespaces - generally 2GB to 8GB - zz is volume number
/data/oracle/xxxx/redo01a - odd numbered redo logs go here - generally .5GB
/data/oracle/xxxx/redo01b - odd numbered mirrored redo logs go here - generally .5GB
/data/oracle/xxxx/redo02a - even numbered redo logs go here - generally .5GB
/data/oracle/xxxx/redo02b - even numbered mirrored redo logs go here - generally .5GB
/data/oracle/xxxx/arch - archived redo logs - only required for production databases - generally 8GB or larger - if this fills up database hangs.
/data/oracle/xxxx/exports - database export files go here -generally 4GB or larger.
Rgds...Geoff