- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Planing Oracle database & application
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
тАО10-07-2003 11:29 PM
тАО10-07-2003 11:29 PM
Could anybody help me to plan VGs and FSs
for an application, based on Oracle9 dbase,
OS HPUX11,mashine rp8400 and storage HP StorageWorks.
The initial parameters are:
-70 GB for software,system
tablespaces,rollback,temp..);
-1.3-1.4 TB for data, based on RAID5;
How I have to design my VGs in order to
phisically separate software, system, data,indexes,rollback,segments,log files..?
What is the usual solution?
Is there any special remarks about kernel parameters,connected with Oracle?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-07-2003 11:33 PM
тАО10-07-2003 11:33 PM
Re: Planing Oracle database & application
Keep your root volume group separate. Usually the root vg is placed on internal disk and mirrored using MirrorDisk/UX. Keep all your data in separate volume groups, probably on external storage. We use vg01 for non-db data and vg02 for the database itself.
Pete
Pete
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-07-2003 11:38 PM
тАО10-07-2003 11:38 PM
Re: Planing Oracle database & application
When we migrated from oracle 8 to oracle 9 there were about 10 kernel parameters we had to change. There is documentation on which parameters that comes with oracle or can be downloaded from oracle's site.
--Jim
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-07-2003 11:43 PM
тАО10-07-2003 11:43 PM
Re: Planing Oracle database & application
Let me add that Oracle reccomends Raid 1 or Raid 10 for data and rollback.
On a database that large, its costly but if you don't do it, expect performance issues at high load factors.
shmmax should be maxed out which means 25% of system memory, which is defined as swap plus memory. shmseg should be set based on anticipated user load.
Having all the oracle stuff in the same volume group will not hurt performance, even with mixed Raid 10 and Raid 5 Luns. Just put them in different logical volumes, don't make one massive filesystem for everything.
The HP-UX OS will fit in less than 20 GB of space even with a ton of add in OS software.
Here is some good kmtune output. Attached.
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
тАО10-08-2003 12:15 AM
тАО10-08-2003 12:15 AM
SolutionWe also alternate controler from disk to disk in the vg.
we use a 64Kb stripe size.
check these links
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=193104
http://forums1.itrc.hp.com/service/forums/parseCurl.do?CURL=%2Fcm%2FQuestionAnswer%2F1%2C%2C0xd6b250dde50cd71190050090279cd0f9%2C00.html&admit=716493758+1065615232533+28353475
http://forums1.itrc.hp.com/service/forums/parseCurl.do?CURL=%2Fcm%2FQuestionAnswer%2F1%2C%2C0x9338b941255cd71190080090279cd0f9%2C00.html&admit=716493758+1065615290814+28353475
Rgds,
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-08-2003 12:30 AM
тАО10-08-2003 12:30 AM
Re: Planing Oracle database & application
Don't get too hung up on which disks to do what because the array is going to split it anyway. Surprisingly, under 11.11, Oracle actually performs better (and I have measured it) using fully cooked files for everything. If you do choose to use raw/io, dont use devices like /dev/vg10/rlvol1 but instead use /u01/oradata/datafile01.dbf and then symbolically link /u01/oradata/datafile01.dbf to /dev/vg10/rlvol1. Using tyhis method of indirection will allow you to easily move the i/o around (or go to fully cooked files) with no Oracle changes.
My best advice is however much memory you think you need, double it. Oracle 9 needs huge SGA's to really perform well.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-08-2003 12:40 AM
тАО10-08-2003 12:40 AM
Re: Planing Oracle database & application
Clay's advice is good as always.
You cannot have enough memory for Oracle, because Oracle eats resources like popcorn.
Try to spread the io-load through several channels ( alternate paths / devices ).
Mirror your control and logfiles on different disks and controlers if possible.
Go for two locations of offline log files
( running the database in archivelog mode ).
Did you take a look at the documentation ?
Install guide / release notes etc
http://otn.oracle.com/documentation/oracle9i.html
Rgds
Alexander M. Ermes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-08-2003 03:17 AM
тАО10-08-2003 03:17 AM
Re: Planing Oracle database & application
techniques for data placement and striping.
Recommendations:
In general, RAID usually impacts write operations more than read operation.
This is specially true where parity need to be calculated (RAID 3, RAID 5, etc).
Online or archived redo log files can be put on RAID 1 devices.
You should not use RAID 5. 'TEMP' tablespace data files should also go on
RAID1 instead of RAID5 as well. The reason for this is that streamed
write performance of distributed parity (RAID5) isn't as good as that of
simple mirroring (RAID1).
Swap space can be used on RAID devices without affecting Oracle.
====================================================================================
RAID Type of RAID Control Database Redo Log Archive Log
File File File File
====================================================================================
0 Striping Avoid* OK* Avoid* Avoid*
------------------------------------------------------------------------------------
1 Shadowing OK OK Recommended Recommended
------------------------------------------------------------------------------------
0+1 Striping + OK Recommended Avoid Avoid
Shadowing (1)
------------------------------------------------------------------------------------
3 Striping with OK Avoid Avoid Avoid
Static Parity (2)
------------------------------------------------------------------------------------
5 Striping with OK Avoid Avoid Avoid
Rotating Parity (2)
------------------------------------------------------------------------------------
* RAID 0 does not provide any protection against failures. It requires a strong backup
strategy.
(1) RAID 0+1 is recommended for database files because this avoids hot spots and gives
the best possible performance during a disk failure. The disadvantage of RAID 0+1
is that it is a costly configuration.
(2) When heavy write operation involves this datafile
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-08-2003 03:26 AM
тАО10-08-2003 03:26 AM
Re: Planing Oracle database & application
I can't overemphasize the RAID issue.
A. Clay makes excellent points with regards to the OS, I/O and RAID.
This tuning doc is maintainted by HP's top oracle tuning guru.
http://www2.itrc.hp.com/service/cki/search.do?category=c0&docType=Security&docType=Patch&docType=EngineerNotes&docType=BugReports&docType=Hardware&docType=ReferenceMaterials&docType=ThirdParty&searchString=UPERFKBAN00000726&search.y=8&search.x=28&mode=id&admit=-1335382922+1065626708921+28353475&searchCrit=allwords
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
тАО10-08-2003 04:14 AM
тАО10-08-2003 04:14 AM
Re: Planing Oracle database & application
Attaching a text copy.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com