HPE Community read-only access December 15, 2018
This is a maintenance upgrade. You will be able to read articles and posts, but not post or reply.
Hours:
Dec 15, 4:00 am to 10:00 am UTC
Dec 14, 10:00 pm CST to Dec 15, 4:00 am CST
Dec 14, 8:00 pm PST to Dec 15, 2:00 am PST
cancel
Showing results for 
Search instead for 
Did you mean: 

filesystem block size

 
SOLVED
Go to solution
pa8700
Regular Advisor

filesystem block size

wether I can change the block size of a file system once created. Wether it needs down time ? some body sugested that 8k is good for oracle performance
6 REPLIES
Steven E. Protter
Exalted Contributor
Solution

Re: filesystem block size

Shalom,

To change this you would need to back up your data, rebuild the logical volumes and file systems and then restore the data.

Don't bother, a number of people have actually tested this concept out and not gotten a significant boost in oracle performance.

Proper tuning of kernel parameters, system patching and management of the Oracle SGA settings all have far more impact on performance than block size on the file system.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
James R. Ferguson
Acclaimed Contributor

Re: filesystem block size

Hi:

The block size ('bsize') is set at creation time and can't be changed thereafter.

The block size for files on the file system represents the smallest amount of disk space allocated to a file. The values are powers of 2 and range from 1024-8192 bytes with an appropriate default being chosen based on the size of the filesystem at creation. See the 'mkfs_vxfs' manpages for more information.

Regards!

...JRF...
Bill Hassell
Honored Contributor

Re: filesystem block size

> some body sugested that 8k is good for oracle performance

Years ago (probably more than 15), Oracle recommended this for 'performance' in a blanket statement for all flavors of Unix. Unfortunately, this statement still persists even though it has no relevance with current VxFS filesystems (and very little effect for HFS).

The biggest change in performance for Oracle is to look at the DB design and the queries. Reducing disk I/O in Oracle is many times more effective than fiddling with filesystems, striping, cache sizes, etc.


Bill Hassell, sysadmin
Suraj K Sankari
Honored Contributor

Re: filesystem block size

Hi,

>>wether I can change the block size of a file system once created.
As said above you need to take backup and rebuild the same.....

Wether it needs down time ?
down time for what server?
if its about server then no. for file system then you need to distroy the vg and recreate it again...

Suraj
Johnson Punniyalingam
Honored Contributor

Re: filesystem block size

>>wether I can change the block size of a file system once created<<<

you need use "newfs" command to specfiy your bloack size once you have create file system using lvcreate" than follow has below

newfs -F vxfs -b 8192 -o largefiles /dev//r

>>>>Wether it needs down time ?<<<

if its new file system creation - NO downtime required
Problems are common to all, but attitude makes the difference
Johnson Punniyalingam
Honored Contributor

Re: filesystem block size

>>some body sugested that 8k is good for oracle performance<<

As per the attachment , Yes
Problems are common to all, but attitude makes the difference