Monday, May 26, 2008

Redo Block Size

OS specific and coded into oracle code.
select max(lebsz) from sys.x$kccle;


Solaris, AIX, Windows NT/2000, Linux, Irix, DG/UX, OpenVMS, NetWare, UnixWare, DYNIX/ptx :- 512 bytes

HP-UX, Tru64 Unix :- 1024 bytes

SCO Unix, Reliant Unix :- 2048 bytes

MVS, MPE/ix :- 4096 bytes