Oracle Internals
JulianDyke.com

Welcome

Seminars

Consultancy

Calendar

Presentations

Diagnostics

Internals

References

Acknowledgements

Fixed View: X$KCBWBPD

Versions

Oracle Version X$ Version
10.1.0.3.0 4
10.2.0.1.0 4
11.1.0.6.0 4

Columns

Version 4

Column Name Data Type
ADDR RAW(4)
INDX NUMBER
INST_ID NUMBER
BP_NAME VARCHAR2(20)
BP_ID NUMBER
BP_BLKSZ NUMBER
BP_GRANSZ NUMBER
BP_BUFPERGRAN NUMBER
BP_LO_SID NUMBER
BP_HI_SID NUMBER
BP_SET_CT NUMBER
BP_SIZE NUMBER
BP_STATE NUMBER
BP_CURRGRANS NUMBER
BP_TGTGRANS NUMBER
BP_PREVGRANS NUMBER

Indexes

Version 4

Version 4 of this fixed view has 2 indexes

Index Number Index Position Column Name
10ADDR
20INDX