Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

migration of large oracle database from 7.3 to 8i

joe clark
Advisor

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.
2 REPLIES
Mott Given
Frequent Advisor

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
A. Clay Stephenson
Acclaimed Contributor

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.
If it ain't broke, I can fix that.