HPE Community
Operating System - HP-UX
1753783 Members
7150 Online
108799 Solutions
New Discussion юеВ

Oracle Database implementation on UNIX servers

 
MINGAM
New Member

тАО07-07-2000 02:11 AM

тАО07-07-2000 02:11 AM

Oracle Database implementation on UNIX servers

When you create Oracle 8.0.5 Database ( whith size bigger than 200 Go), Is there a rule to apply for better performance between LVM, VXFS block size under HP-UX 11 and ORACLE block size.
0 Kudos
Reply
2 REPLIES 2
Andreas Voss
Honored Contributor

тАО07-07-2000 02:47 AM

тАО07-07-2000 02:47 AM

Re: Oracle Database implementation on UNIX servers

Hi,

i think it's recommended that the block size of Oracle should be the same as the block size of the filesystem.
We use 8192.
To set this at creation time for the filesystem we used:
newfs -F vxfs -b 8192 /dev/vgXX/lvolXX

Regards

Andrew
0 Kudos
Reply
Brian M. Fisher
Honored Contributor

тАО07-07-2000 03:30 AM

тАО07-07-2000 03:30 AM

Re: Oracle Database implementation on UNIX servers

Andrew is correct, Oracle recommends the block sizes be the same.

Brian
<*(((>< er
Perception IS Reality
0 Kudos
Reply
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.