|
Welcome
Seminars
Consultancy
Presentations
Diagnostics
Internals
Acknowledgements
|
Fixed View: X$BUFFER2
Versions
| Oracle Version |
X$ Version |
| 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 |
| MSGID |
RAW(16) |
| CORRID |
VARCHAR2(30) |
| SEQUENCE_NUM |
NUMBER |
| MSG_NUM |
NUMBER |
| STATE |
NUMBER |
| PRIORITY |
NUMBER |
| EXPIRATION |
NUMBER |
| ENQ_TIME |
TIMESTAMP(20) |
| ENQ_UID |
NUMBER |
| ENQ_USER_NAME |
VARCHAR2(30) |
| RETRY_COUNT |
NUMBER |
| SENDER_NAME |
VARCHAR2(30) |
| SENDER_ADDRESS |
VARCHAR2(1024) |
| SENDER_PROTOCOL |
NUMBER |
| DEQUEUE_MSGID |
RAW(16) |
| SRCSEQUENCE_NUM |
NUMBER |
| SUBSCRIBER_ID |
NUMBER |
| EXCEPTIONQ_SCHEMA |
VARCHAR2(30) |
| EXCEPTIONQ_NAME |
VARCHAR2(30) |
Indexes
Version 1
Version 1 of this fixed view has one index
| Index Number |
Index Position |
Column Name |
| 1 | 0 | OBJNO |
|
