- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: migration of large oracle database from 7.3 to...
Operating System - HP-UX
1752243
Members
4662
Online
108785
Solutions
Forums
Categories
Company
Local Language
юдл
back
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
юдл
back
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
Blogs
Information
Community
Resources
Community Language
Language
Forums
Blogs
Topic Options
- 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
тАО03-15-2001 07:45 AM
тАО03-15-2001 07:45 AM
migration of large oracle database from 7.3 to 8i
I am in the process of moving a large oracle app onto a V-2500 running 11.0 connected to
an EMC 3700 using powerpath. I had 2 questions
should I span the database and or the filesystems across 4 hypervolumes per vg group,
or establish a seperate vg per hypervolume so
the active db tables don't clash with each other. 2nd question was has anyone see performance improvement with any changes to the kernel or vxfs configuration or else where to improve oracle performance.
an EMC 3700 using powerpath. I had 2 questions
should I span the database and or the filesystems across 4 hypervolumes per vg group,
or establish a seperate vg per hypervolume so
the active db tables don't clash with each other. 2nd question was has anyone see performance improvement with any changes to the kernel or vxfs configuration or else where to improve oracle performance.
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-15-2001 09:34 AM
тАО03-15-2001 09:34 AM
Re: migration of large oracle database from 7.3 to 8i
Another site doing the same type of Oracle database upgrade benefited significantly from making changes in the ncsize and ninode kernel parameters, that were modified as follows:
Previous Current
ninode 27808 10000
ncsize NINODE + VX_NCSIZE 4096
Mott Given, Defense Logistics Agency
Previous Current
ninode 27808 10000
ncsize NINODE + VX_NCSIZE 4096
Mott Given, Defense Logistics Agency
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-15-2001 11:58 AM
тАО03-15-2001 11:58 AM
Re: migration of large oracle database from 7.3 to 8i
Best vxfs options I've found for all oracle data and indexes except redo logs and archive logs is convosync=direct,mincache=direct,dalaylog,nodatainlog (this bypasses the unix buffering and gives all the advantages of raw devices). Redo logs and archive logs should be mounted delaylog,datainlog.
Because almost all of the buffering in now done in the SGA you can reduce the amount of
unix buffers. I find best results by turning
off dynamic buffer cache and setting bufpages to about 80000 (320 MB) on a machine with a large amount of memory.
Because almost all of the buffering in now done in the SGA you can reduce the amount of
unix buffers. I find best results by turning
off dynamic buffer cache and setting bufpages to about 80000 (320 MB) on a machine with a large amount of memory.
If it ain't broke, I can fix that.
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.
News and Events
Support
© Copyright 2024 Hewlett Packard Enterprise Development LP