05-25-2000 06:36 AM
Solved! Go to Solution.
05-25-2000 06:42 AM
The memory uses 4K pages, and the filesystems use different blocksizes.
To find out on a filesystem by filesystem basis do :-
05-25-2000 10:05 AM
05-25-2000 10:19 AM
05-25-2000 07:36 PM
I believe you are referring to the filesystem block size.
For good I/O performance, there is indeed an Oracle recommendation requiring that the database block size should not be larger than the filesystem block size. As a rule of thumb, deciding on the database block size depends on your oracle database and oracle application, that is, how large are your tables and how large are the records.
05-26-2000 03:02 AM
The block size to usew for oracle is 4K you can also run dmesg command to see the physical and logical page sizes.