Oracle Internals
JulianDyke.com

Welcome

Seminars

Consultancy

Calendar

Presentations

Diagnostics

Internals

References

Acknowledgements

Fixed View: X$ACTIVECKPT

Versions

Oracle Version X$ Version
10.1.0.3.0 2
10.2.0.1.0 3
11.1.0.6.0 3

Columns

Version 2

Column Name Data Type
ADDR RAW(4)
INDX NUMBER
INST_ID NUMBER
NXT_ACT_ENT RAW(4)
PRV_ACT_ENT RAW(4)
NXT_CHLD_ENT RAW(4)
PRV_CHLD_ENT RAW(4)
CKPT_SCN_BAS NUMBER
CKPT_SCN_WRP NUMBER
CKPT_TIM NUMBER
CKPT_ALLOC_THR NUMBER
CKPT_RBA_SEQ NUMBER
CKPT_RBA_BNO NUMBER
CKPT_RBA_BOF NUMBER
CKPT_EN_THR_BITVEC RAW(8)
RCV_SO RAW(4)
CKPT_ID NUMBER
TSN# NUMBER
OBJ_ID NUMBER
CKPT_ABS_FIL_NUM NUMBER
CKPT_NUM_FILES_EXPTD NUMBER
CKPT_ENQUEUE RAW(4)
PARENT_ENT RAW(4)
CKPT_FILES_TOTAL NUMBER
CKPT_WAITER RAW(4)
CKPT_BUFFER_CNT NUMBER
CKPT_TYPE NUMBER
CKPT_PRIORITY NUMBER
CKPT_FLAGS NUMBER

Version 3

Column Name Data Type
ADDR RAW(4)
INDX NUMBER
INST_ID NUMBER
NXT_ACT_ENT RAW(4)
PRV_ACT_ENT RAW(4)
NXT_CHLD_ENT RAW(4)
PRV_CHLD_ENT RAW(4)
CKPT_SCN_BAS NUMBER
CKPT_SCN_WRP NUMBER
CKPT_TIM NUMBER
CKPT_ALLOC_THR NUMBER
CKPT_RBA_SEQ NUMBER
CKPT_RBA_BNO NUMBER
CKPT_RBA_BOF NUMBER
CKPT_EN_THR_BITVEC RAW(132)
RCV_SO RAW(4)
CKPT_ID NUMBER
TSN# NUMBER
OBJ_ID NUMBER
CKPT_ABS_FIL_NUM NUMBER
CKPT_NUM_FILES_EXPTD NUMBER
CKPT_ENQUEUE RAW(4)
PARENT_ENT RAW(4)
CKPT_FILES_TOTAL NUMBER
CKPT_WAITER RAW(4)
CKPT_BUFFER_CNT NUMBER
CKPT_TYPE NUMBER
CKPT_PRIORITY NUMBER
CKPT_FLAGS NUMBER

Indexes

Version 2

Version 2 of this fixed view does not have any indexes

Version 3

Version 3 of this fixed view does not have any indexes