Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OS block size change

761712Feb 7 2011 — edited Feb 7 2011
Hi DBA gurus,

I have a situation where DB is performing slowly.
ADDM analysis and other AWR report findings showing IO is slow.

UNIX Sysadmin folks found that OS block size 1K where it should have been 8K. file systems are created wrongly with 1K OS blocks.

I have lot of Datafiles created in the partitions. What is the way to increase the block size to 8K?

Do I have to recreate the DB if underlying OS block size change?

i have
/oradb1
/oradb2 partitions with OS block 1K size

if UNIX creates new files /oradb3 and /oradb4 with 8K block size what do I need to do to make the change?

Thanks in advance.
This post has been answered by sb92075 on Feb 7 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 7 2011
Added on Feb 7 2011
5 comments
100 views