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
тАО12-31-2007 08:43 AM
тАО12-31-2007 08:43 AM
Oracle
Can anyone tell me what would be the best configuration for installing an Oracle DB on HP-UX 11i?
1) 1 VG 1 LV
2) 1 VG many LVs
3) More than 1 VG with 1 LV
4) More than 1 VG with more than 1 LV
5) Other
What would be the best configuration for the best performance?
As of right now we are running Oracle under 1 Volume group with only 1 logical volume. This is causing a bottelneck with our disk which are on an XP24K.
Joe
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-31-2007 11:59 AM
тАО12-31-2007 11:59 AM
Re: Oracle
If you everything in one LV than it'll be a bottleneck.
First specify from the oracle point of view that what you want to do.
You can specify oracle binary in one LV, Archive log in one LV, backup in one LV, logs in one LV.
Then think how many disk you need to create these LV's. you can split the disk in LV's i.e for binary LV if you need 2 LV's then take one LUN from a disk and another LUN from other disk.
from VG point of view you can do it like your ways. But one thing if you create many VG's you need to do more administrative task for this.
disk bottleneck mostly depends upon disks as well as application load and kernel configuration.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-31-2007 03:17 PM
тАО12-31-2007 03:17 PM
Re: Oracle
It discusses file layout in lots of detail.
From your choices - I vote for 4) - see document for details.
https://forums11.itrc.hp.com/service/forums/questionanswer.do?threadId=1170408
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-01-2008 05:51 AM
тАО01-01-2008 05:51 AM
Re: Oracle
(1) You need to have multiple VG's for the purpose of resilience of disk and good IO distribution.
So, keeping the software of Oracle and database in seperate disk is highly recommended.
For example, you may have any volume group called vg_application to store all softwares like (Oracle software, iAS etc). seperate logical volume for Oracle can be created on vg_application (lv_oracle).
(2) DB should be created on seperate volume group and that it should be mirrored. vg_database can be created for this purpose. Here we need to make sure that there are seperate LV's for different tablespace of database. You may consider having seperate LV's for system, temp, larger tablespace. All of smaller LV's that are less frequently used can go together in one LV's.
(3) Backup and redolog group should be on seperate volume group together. This disk should be mirrored as well. You need to make sure that the size of the LV should be atleast 2.5 times more than your size of database (you may trade off based on volumes of transaction on your DB).
Thanks,
Srikanth
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-01-2008 06:45 AM
тАО01-01-2008 06:45 AM
Re: Oracle
My preferences:
1. Define RAID1 LV using sufficient disks that would cater for the OS and the area where i would be installing the Oracle software.
2. use the rest of the disk space available for defining an ASM area that would be used for my Oracle Database.
As you must already know ASM is just like raid 10 in effect -- done at the extent level of database segments instead of some os stripe size.
hope this helps!
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-04-2008 10:11 AM
тАО01-04-2008 10:11 AM
Re: Oracle
I have similar environment XP24K, Oracle9i & HPUX 11.23 (i must say that it haves a very high performance rate)
1) Command to create vgs:
vgcreate -p 32 -s 256 -e 480 -g PVG_name /dev/vgORAx \
2) Each vg has 8 disks, same size and same RAID type; actually each vg has 4 lvs
3) The database logs (archivelogs, redologs) are in RAID 1 (2d + 2p), 1 vg 5 lvs
4) Rest of database are in RAID 5 (14d + 2p).
5) Logical volumes were created as follows:
lvcreate -L
As a especial note you must calculate the segment size of your volume groups according to the max size that you think your databse grows to and also affects the number of disks the volume group has and of course their size.
With this configuration you will get a great performance and the disk throughput will be wonderfull.
Forget to say that the XP24K disks are 144 gb 15 krpm.
And answering your question option 4 seems to be the best one to me.
Hope this helps. Regards!