- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle and LUNs on VA7100
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
тАО07-25-2002 05:27 AM
тАО07-25-2002 05:27 AM
Oracle and LUNs on VA7100
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-25-2002 05:38 AM
тАО07-25-2002 05:38 AM
Re: Oracle and LUNs on VA7100
...it is wise to place each major Oracle data group on SEPARATE LUNs...
Yes, it is only true when each LUN is mapped to a physical disk (and it is much better if each disk again is connected to a different controller) so the I/O can be efficient. As for VA7100, you can forget about this concept since VA7100, by default, is an AUTORAID array which will try tom maximize the I/O performance for you.
For detailed info, you should read "HP surestore virtual arrays 7100 & 7400".
Hai
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-25-2002 07:18 AM
тАО07-25-2002 07:18 AM
Re: Oracle and LUNs on VA7100
Here is an issue raised on Oracle Metalink.
For oracle, i would recommend using Locally Managed Tablespaces in any cases. Create tablespaces with uniform extent sizes - e.g. 64K, 1M, 10M, etc according and create objects (classied as small, medium, large) accordingly in the tablespaces...
============================================================
From: JF Cote 25-Jan-02 19:56
Subject: SAN vs. Tablespace/Datafile
RDBMS Version: 9.0.1
Operating System and Version: HP-UX 11i
Error Number (if applicable):
Product (i.e. SQL*Loader, Import, etc.): none
Product Version:
SAN vs. Tablespace/Datafile
Hi,
I am currently migrating a 7.3.4 from hp-ux 10.20 to 9.0.1 to hp-ux 11i (with a san storage).
Actually, our tables are spread into different tablespaces, tablespaces are spread on different disks. Example: table 1 t1 is stored in tablespace A (ta) and table 2 t2 is stored in tablespace B tb. The ta & tb are stored on different disk to avoid contention.
Now we are going to install the db on a hp SAN (Va7100 with 6 disks in autoraid).
Questions: is there any benefit to keep the actual structure or should i merge all these tables in a single tablespace? Doing it, i will save a lot of spaces and the space management will be easier.
Any idea?
TIA,
JF Cote
--------------------------------------------------------------------------------
From: Bill Schott 25-Jan-02 20:08
Subject: Re : SAN vs. Tablespace/Datafile
With large SANs, I've adopted (and recommend) the small/medium/large concept in which objects are assigned based on their extent size, with 1 extent size per tablespace. Extra large objects, continue to get their own tablespaces.
Basically with SANs, you no longer use tablespaces to balance IO. But putting all in one causes trouble as well with fragmentation issues.
============================================================
Hope this helps!
Best Regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-25-2002 08:29 AM
тАО07-25-2002 08:29 AM
Re: Oracle and LUNs on VA7100
Are you saying that I can forget about the concept of placing Oracle data groups (indicies,redo logs, etc)on different VA LUNS (since I have no control over which spindles a LUN is mapped to)?
In other words, previous discussion threads on VA7100/Oracle issues where experts refer to placing Oracle data groups on different LUNS are bogus recommendations?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-25-2002 08:57 AM
тАО07-25-2002 08:57 AM
Re: Oracle and LUNs on VA7100
Are you saying that I can forget about the concept of placing Oracle data groups (indicies,redo logs, etc)on different VA LUNS (since I have no control over which spindles a LUN is mapped to)?
...
Yes.
You can consult with HP support to be more convinced about this.
Hai
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-25-2002 09:14 AM
тАО07-25-2002 09:14 AM
Re: Oracle and LUNs on VA7100
Of course, I still created my different filesytems names and separate tablespaces, etc. - just to give me some sort of order.
Jeanine
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-25-2002 09:47 AM
тАО07-25-2002 09:47 AM
Re: Oracle and LUNs on VA7100
Data are in RAID 0+1 when it is being referenced a lot (faster I/0 while still maintaining data redundancy) and in RAID 5 DP when they are not referenced (space saver+data redundancy). If you use this array solely for ORACLE, you can set this array to support only RAID 0+1 (refer to HP surestore command view sdm manual)
Hai
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-25-2002 09:52 AM
тАО07-25-2002 09:52 AM
Re: Oracle and LUNs on VA7100
It is a bit strange to be out of the "load balance by spindle" business, but it's actually quite wonderful if it really works well. But I had heard opposing advise and wanted to get it clarified!
Thanks again!