Oracle Log Block Size
Although the size of redo entries is measured in bytes, LGWR writes the redo to the log files on disk in blocks. The size of redo log blocks is fixed in the Oracle source code and is operating system specific. Oracle's documentation uses the term "operating system block size" to refer to the log block size. Normally it is the smallest unit of I/O supported by the operating system for raw I/O, but on some operating systems it is the smallest possible unit of file system based I/O. The following table shows the most common log block sizes and some of the operating systems that use them.
Log Block Size | Operating Systems |
---|---|
512 bytes | Solaris, AIX, Windows NT/2000, Linux, Irix, DG/UX, OpenVMS, NetWare, UnixWare, DYNIX/ptx |
1024 bytes | HP-UX, Tru64 Unix |
2048 bytes | SCO Unix, Reliant Unix |
4096 bytes | MVS, MPE/ix |
The log block size is the unit for the setting of the log_checkpoint_interval , _log_io_size and max_dump_file_size parameters. Therefore, it is an important constant to know. If your operating system is not listed in the table above, then you can find your log block size using the following query.
select max(lebsz) from sys.x$kccle;
This query is available as the APT script . If your operating system is not listed in the table above, please click on the feedback icon below and send us an email so that we can add it to the list.
The log block size can also be inferred from the system statistics in StatsPack reports. There is a 16 byte header for each log block, and the size of the data area is approximately the number of bytes of redo generated ( redo size ) plus the number of bytes of redo space left unused ( redo wastage ) divided by the number of log blocks written ( redo blocks written ). Thus the approximate formula is
16 + ( redo size + redo wastage ) / redo blocks written
This formula will commonly understate the log block size by a few bytes, because it does not allow for redo that has been generated but not yet written, and the redo size statistic is commonly a little inaccurate.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/8484829/viewspace-2151132/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-27046: file size is not a multiple of logical block sizeBloC
- DB_BLOCK_SIZE and DB_CACHE_SIZE in OracleBloCOracle
- error:unable to get logical block size for spfileErrorBloC
- oracle的塊 db_block_sizeOracleBloC
- Oracle10g 五種不同的block sizeOracleBloC
- oracle block_size 為非標準塊的時候OracleBloC
- DB_BLOCK_SIZE Initialization Parameter (92)BloC
- Oracle OCP 1Z0-053 Q632(Standard Block Size )OracleBloC
- Initianization Parameter (1) : DB_BLOCK_SIZEBloC
- oracle 線上修改online redo logfiles size 大小Oracle
- mysql innodb_log_file_size 和innodb_log_buffer_size引數MySql
- SAP Security Audit log size
- 【BBED】使用bbed解決 the amount of space used is not equal to block sizeBloC
- Meaning of Block size in tcode R3AC1BloC
- 【Linux】bad geometry: block count 11796480 exceeds size of deviceLinuxBloCdev
- oracle dump blockOracleBloC
- oracle block type!OracleBloC
- ORACLE BLOCK DUMPOracleBloC
- oracle hot blockOracleBloC
- oracle block phisical address to block#OracleBloC
- Oracle Find block in ASMOracleBloCASM
- oracle block 格式 (zt)OracleBloC
- 9i建立非標準BLOCK_SIZE資料庫(二)BloC資料庫
- 9i建立非標準BLOCK_SIZE資料庫(一)BloC資料庫
- mongodb線上調整Oplog Size的值MongoDB
- Oracle NoLogging Append 方式減少批量insert的redo_sizeOracleAPP
- Oracle Block Cleanouts 塊清除OracleBloC
- oracle壞塊Block CorruptionsOracleBloC
- Oracle資料塊blockOracleBloC
- Oracle BBED(block browse and editor)OracleBloC
- InnoDB: Error: log file ./ib_logfile0 is of different size 5242880 bytesError
- 如何選擇配置 MySQL innodb_log_file_sizeMySql
- Oracle (block clean out) oracle的塊清除OracleBloC
- tune2fs -l 檢視檔案系統資訊 (os block size等)BloC
- Alert.log shows No Standby Redo Logfiles Of Size 153600 Blocks AvailableBloCAI
- Oracle OCP 1Z0 053 Q517(Block Media Recovery&Archivelog Mode&Flashback Logging)OracleBloCHive
- 新增檔案的時候報錯:ORA-19502 block number 2050049 (block size=512): ORA-27072:BloC
- 【BLOCK】Oracle 塊管理常用SQLBloCOracleSQL