(새 문서: === 데이터 블럭의 구조 === https://misogain.wordpress.com/wp-content/uploads/2024/05/data_block_layer.png) |
편집 요약 없음 |
||
| 2번째 줄: | 2번째 줄: | ||
https://misogain.wordpress.com/wp-content/uploads/2024/05/data_block_layer.png | https://misogain.wordpress.com/wp-content/uploads/2024/05/data_block_layer.png | ||
===블럭의 구성 항목별 사이즈 조회 === | |||
<source lang=sql> | |||
select component, type, description, type_size | |||
from v$type_size | |||
where component in ('KCB', 'KTB'); | |||
</source> | |||
<source lang=sql> | |||
COMPONEN TYPE DESCRIPTION TYPE_SIZE | |||
-------- -------- -------------------------------- ---------- | |||
KCB KCBH BLOCK COMMON HEADER 20 | |||
KTB KTBIT TRANSACTION VARIABLE HEADER 24 | |||
KTB KTBBH TRANSACTION FIXED HEADER 48 | |||
KTB KTBBH_BS TRANSACTION BLOCK BITMAP SEGMENT 8 | |||
</source> | |||
2025년 9월 22일 (월) 14:09 판
데이터 블럭의 구조
블럭의 구성 항목별 사이즈 조회
select component, type, description, type_size
from v$type_size
where component in ('KCB', 'KTB');
COMPONEN TYPE DESCRIPTION TYPE_SIZE -------- -------- -------------------------------- ---------- KCB KCBH BLOCK COMMON HEADER 20 KTB KTBIT TRANSACTION VARIABLE HEADER 24 KTB KTBBH TRANSACTION FIXED HEADER 48 KTB KTBBH_BS TRANSACTION BLOCK BITMAP SEGMENT 8