General
cancel
Showing results for 
Search instead for 
Did you mean: 

db_block_size and operating system block_size parameter

SOLVED
Go to solution
Jose Luis De Diego
Occasional Contributor

db_block_size and operating system block_size parameter

Hi all.

Does anybody know how to find out the OS block_size on vxfs in HPUX 11?

I'm trying to adjust SGA, and one of the parameters involved is, as you all know, db_block_size, which must be multiple of the OS block_size.

I know you define it when creating the file system, but I don't remember the value, and don't know where nor how to visualize the value.

Thanks in advance.
5 REPLIES
John Palmer
Honored Contributor

Re: db_block_size and operating system block_size parameter

fstyp -v /dev/vg??/???

will return the blocksize as f_bsize and the fragment size as f_frsize.

Regards,
Joh
Duncan Edmonstone
Honored Contributor
Solution

Re: db_block_size and operating system block_size parameter

Two ways:

fstyp -v /dev/vgXX/lvolY

And look at the value given for f_frsize

OR

mkfs -m /dev/vgXX/lvolY

which shows you the original mkfs command used to create the file system.

Unless it was specified at creation time, VxFS file systems will default to a block size of 1024 - this is probably a bit small for most Oracle databases - most people seem happy with a block size of 8192.

HTH

Duncan

HTH

Duncan
Jose Luis De Diego
Occasional Contributor

Re: db_block_size and operating system block_size parameter

I understand the parameter Oracle recommends to be a multiple of the FS block_size, *for vxfs*, is f_frsize or fragment size, which is the same as specified when creating the FS with mkfs and bsize option.

Thanks, Duncan and John.

Greetings.
Darrell Allen
Honored Contributor

Re: db_block_size and operating system block_size parameter

Hi Jose,

There is much confusion on this issue. Here's a doc:
http://us-support3.external.hp.com/cki/bin/doc.pl/sid=c4b25c3a08f59ac82a/screen=ckiDisplayDocument?docId=200000054230626

Also, from man newfs_vxfs:
-b block_size File system block size in bytes. The default value used is 1024 bytes.

Look for f_frsize from:
fstyp -v /dev/vg##/lvol#

Look for fragment size from:
df -g /mount_point

There's quite a number of threads in the forums about this. I suggest you search (limiting the domain to itrc.hp.com) at http://www.google.com/advanced_search

Darrell
"What, Me Worry?" - Alfred E. Neuman (Mad Magazine)
Jose Luis De Diego
Occasional Contributor

Re: db_block_size and operating system block_size parameter

Darrell.

The info you gave through man pages and other commands have been enough for me to solve my doubts, specially man newfs_vxfs, man df, and man statvfs, which is the C system funtion for retrieving file system info, and that is called from command line interfaces like df, and so on.

Here is an extract of man statvfs, which I think make clear the issue:

man statvfs
Reformatting entry. Wait... done

statvfs(2) statvfs(2)

NAME
statvfs, fstatvfs - get file system information. These C funtions are called from command line interfaces, like df.

DESCRIPTION
statvfs() returns information about a mounted file system.
...

The statvfs structure contains the following members:

...
ulong f_frsize; /* fundamental file system block size */
...

Of course John and Duncan gave the right answer as well...

;^)

Greetings.