Oracle Internals
JulianDyke.com

Welcome

Seminars

Consultancy

Calendar

Presentations

Diagnostics

Internals

References

Acknowledgements

Fixed View: X$INSTANCE_CACHE_TRANSFER

Versions

Oracle Version X$ Version
10.1.0.3.0 1
10.2.0.1.0 1
11.1.0.6.0 2

Columns

Version 1

Column Name Data Type
ADDR RAW(4)
INDX NUMBER
INST_ID NUMBER
INSTANCE NUMBER
CLASS NUMBER
CR_BLOCK NUMBER
CR_BUSY NUMBER
CR_CONGESTED NUMBER
CURRENT_BLOCK NUMBER
CURRENT_BUSY NUMBER
CURRENT_CONGESTED NUMBER

Version 2

Column Name Data Type
ADDR RAW(4)
INDX NUMBER
INST_ID NUMBER
INSTANCE NUMBER
CLASS NUMBER
LOST NUMBER
LOST_TIME NUMBER
CR_2HOP NUMBER
CR_2HOP_TIME NUMBER
CR_3HOP NUMBER
CR_3HOP_TIME NUMBER
CR_BUSY NUMBER
CR_BUSY_TIME NUMBER
CR_CONGESTED NUMBER
CR_CONGESTED_TIME NUMBER
CURRENT_2HOP NUMBER
CURRENT_2HOP_TIME NUMBER
CURRENT_3HOP NUMBER
CURRENT_3HOP_TIME NUMBER
CURRENT_BUSY NUMBER
CURRENT_BUSY_TIME NUMBER
CURRENT_CONGESTED NUMBER
CURRENT_CONGESTED_TIME NUMBER

Indexes

Version 1

Version 1 of this fixed view does not have any indexes

Version 2

Version 2 of this fixed view does not have any indexes