I am currently trying to attain the size of my redo log buffer. I have read that the log buffer size in init.ora is to be multiplied by the OS block size to establish amount in bytes allocated. My log buffer size parameter is currently 163840.
I beleive my OS block size is either 2048 or 1024.
To prove this I did a :
select * from v$sgastat
The log buffer size was 163840 bytes.
I would have expected this to be at least :-
167772160 (163840 * 1024)
Can anyone plese explain.
Click Here to Expand Forum to Full Width