Filesystem Block size

[big]

Hi,

On 11.2.0.4 on AIX

How can I know Filesystem Block size where the data files are storaged without running a commandes as root?

Is it recorded in any Oracle table?

I don't ask about db_block_size.

Thanks.

[ErmanArslansOracleBlog]

DB block size is the database block size, so the database will format its blocks accordingly..  Database doesn't know/care the Os-Filesystem block size.
So, te value you see in db block size is not the OS - Filesystem block size.

If you are on AIX, you can check the filesystem block size using; lsfs command or using smitty..

[big]

Thanks.

 lsfs -q /db/sgbd/mydb/disk09

Name      Nodename  Mount Pt        VFS  Size  Options  Auto Accounting

/dev/lvrecc1vg1p187 --     /db/sgbd/mydb/disk09 jfs2 83886080 rw     yes no

/dev/lvrecc1vg1p187: The file access permissions do not allow the specified action.



What is block size then? How do you see/calculate it from the output of lsfs?

Regards.

[ErmanArslansOracleBlog]

Use lsfs -q
Run it with root

[ErmanArslansOracleBlog]

If you need to run these types of command without root, you need to implement a superuser configuration (sudo and similar stuff) on AIX level.. Ofcourse, you will do this configuration with root.