05-26-2010
I have to disagree with bakunin ... if you have 4 luns coming from the SAN, than AIX will access the disks in parallel - if you have large tables or many threads / queries in parallel / IO is spread across the VG (I have DBs with tables spanning many 100 GB) - if you only have one lun than it will always be serial.
IBM DB performance specialists still recommend poor man striping for sybase and oracle DBs ... even for raw devices - if you have the option ... if you have only one lun, you obviously don't.
Kind regards
zxmaus
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
what is the reason oracle is giving ora-600 space leak error?
how to rectify this error? (6 Replies)
Discussion started by: varadakumar
6 Replies
2. UNIX for Advanced & Expert Users
Hi @all
Who's able to help me?
I've a running Oracle DB on AIX 4.3.3.
You've also an Oracle Client running for this.
So however, how it's possible, that I can see the CURRENT VERSION of my Oracle CLIENT. I've tried several things,
but it doesn't work. Thanks a lot!
Regards
Oliver :( :( (4 Replies)
Discussion started by: olli2002
4 Replies
3. AIX
Hello, mornig can you help me whit this error: "Oracle Universal Installer cannot be run"
and i can't start the installation of ORACLE 9i...
see you later (1 Reply)
Discussion started by: joseantoniohv
1 Replies
4. AIX
Hi All,
I need to update some AIX servers from 5.2 to 5.3 OR 6.1 .
The management is pressing for 6.1, but on our systems runs Oracle 9.2.0 .
I couldn't find any clear warning about the possibility of compatibility issues between AIX 6.1 and Oracle 9.2.0 but, on the other hand, I couldn't find... (0 Replies)
Discussion started by: padawan75
0 Replies
5. AIX
Hello
Im trying to install oracle on my AIX 5.3 server.
Im doing all things right as Oracle says...
When im trying to run the instalation it gives me an error about JRE.
But i already have JRE installed as you can see...
Someone can help me or guide me?
Im new in with this..
... (1 Reply)
Discussion started by: gfca
1 Replies
6. AIX
hi
can anyone help me by telling step by stem oracle10g installation in AIX 5 .
Munir
mondolsoft
Bangladesh (3 Replies)
Discussion started by: dbamunir
3 Replies
7. AIX
Dear All,
I have a requirement where there are applicaions installed in Unix machine that has to update a set of Oracle data base installed in Windows machine, the question I have here is, which protocol alows Unix application to interact with Database in Windows env. and do we require some... (2 Replies)
Discussion started by: prav_06
2 Replies
8. AIX
Seek help from all of the experts here.
Database Oracle 9.2.0.1.0 run on AIX 5300-07.
The system is running so slow that sometime 1 click of changing screen will take more than 5 minutes.
The hardware in this LPAR is 6CPUs, 21GB-RAM, 42GB-Paging and run on p570 server POWER 5+.
And the vmo... (2 Replies)
Discussion started by: kwliew999
2 Replies
9. UNIX for Advanced & Expert Users
I am setting this up on 5.3 and the problem is I cannot remember how to allocate two IP addresses to a NIC. I have setup an alias on EN0 but when I list it with ifconfig -a it still only shows 1 network address (after a reboot). I know there is something I must do but for the life of me cannot... (1 Reply)
Discussion started by: johnf
1 Replies
10. AIX
Hello All,
I was approached by DBAs, and they want me to create a large_page on AIX and also change oracle file systems to CIO.
They are complaining the system is taking longer time for processing and we are unnecessary wasting memory and CPU for file system cache.
To do that I have to change... (12 Replies)
Discussion started by: m6248m
12 Replies
LEARN ABOUT HPUX
ifc_disable_mgmt_lun
ifc_disable_mgmt_lun(5) File Formats Manual ifc_disable_mgmt_lun(5)
NAME
ifc_disable_mgmt_lun - select whether or not management luns are discovered in the legacy representation of mass storage devices
VALUES
Failsafe
Default
Allowed values
Enable discovery of management luns for array devices.
Disable discovery of management luns for array devices.
Recommended values
DESCRIPTION
Management luns provide the means to access the control ports of Fibre Channel disk arrays. They are represented in both the legacy and
the agile view of storage devices. The legacy representation of a management lun is typically created under a separate virtual extension
bus node. The entry for a legacy management lun looks like this:
On a system with a large number of storage devices connected, creation of management luns can result in an insufficient number of virtual
extension buses for the legacy representation of data luns. Since the number of extension buses on a system is limited to 256, luns
requiring virtual extension buses above 256 will be unusable through legacy device special files. Disabling the discovery and creation of
management luns will free up virtual extension buses for use by data luns.
Who Is Expected to Change This Tunable?
System administrators who expect to use a large number of storage devices requiring more than 256 extension buses through legacy device
special files.
Restrictions on Changing
Changes to this tunable take effect immediately. However, existing management luns will not be removed.
When Should the Tunable Be Turned On?
This tunable should be turned on when the system runs out of extension buses for configuring the legacy representation of data luns.
What Are the Side Effects of Turning the Tunable Off?
None.
When Should the Tunable Be Turned Off?
When the functionality provided by the management luns is desired.
What Are the Side Effects of Turning the Tunable On?
Existing management luns in the legacy representation will show up in the state.
What Other Tunables Should Be Changed at the Same Time?
None.
WARNINGS
All HP-UX kernel tunable parameters are release specific. This parameter may be removed or have its meaning changed in future releases of
HP-UX.
Installation of optional kernel software, from HP or other vendors, may cause changes to tunable parameter values. After installation,
some tunable parameters may no longer be at the default or recommended values. For information about the effects of installation on tun-
able values, consult the documentation for the kernel software being installed. For information about optional kernel software that was
factory installed on your system, see at
AUTHOR
was developed by HP.
SEE ALSO
ioinit(1M), ioscan(1M), kctune(1M).
Tunable Kernel Parameters ifc_disable_mgmt_lun(5)