Oracle Internals
JulianDyke.com

Welcome

Seminars

Consultancy

Calendar

Presentations

Diagnostics

Internals

References

Acknowledgements

Fixed View: X$BUFFER

Versions

Oracle Version X$ Version
10.1.0.3.0 1
10.2.0.1.0 1
11.1.0.6.0 1

Columns

Version 1

Column Name Data Type
ADDR RAW(4)
INDX NUMBER
INST_ID NUMBER
OBJNO NUMBER
QUEUE_ID NUMBER
MSG_ID RAW(16)
CORR_ID VARCHAR2(128)
SEQUENCE_NUM NUMBER
MSG_NUM NUMBER
MSG_STATE NUMBER
MSG_PRIORITY NUMBER
EXPIRATION NUMBER
ENQ_TIME TIMESTAMP(20)
ENQ_USER_ID NUMBER
ENQ_USER_NAME VARCHAR2(30)
SENDER_NAME VARCHAR2(30)
SENDER_ADDRESS VARCHAR2(1024)
SENDER_PROTOCOL NUMBER
ORIGINAL_MSGID RAW(16)
SRCSEQUENCE_NUM NUMBER
SUBSCRIBER_ID NUMBER

Indexes

Version 1

Version 1 of this fixed view has one index

Index Number Index Position Column Name
10OBJNO