|
Welcome
Seminars
Consultancy
Presentations
Diagnostics
Internals
Acknowledgements
|
Fixed View: X$BUFFERED_SUBSCRIBERS
Versions
| Oracle Version |
X$ Version |
| 10.1.0.3.0 |
1 |
| 10.2.0.1.0 |
2 |
| 11.1.0.6.0 |
3 |
Columns
Version 1
| Column Name |
Data Type |
| ADDR |
RAW(4) |
| INDX |
NUMBER |
| INST_ID |
NUMBER |
| QUEUE_ID |
NUMBER |
| SUBSCRIBER_ID |
NUMBER |
| SUBSCRIBER_NAME |
VARCHAR2(30) |
| SUBSCRIBER_ADDRESS |
VARCHAR2(1024) |
| PROTOCOL |
NUMBER |
| SUBSCRIBER_TYPE |
VARCHAR2(30) |
| LAST_BROWSED_SEQ |
NUMBER |
| LAST_BROWSED_NUM |
NUMBER |
| LAST_DEQUEUED_SEQ |
NUMBER |
| LAST_DEQUEUED_NUM |
NUMBER |
| CURRENT_ENQ_SEQ |
NUMBER |
| NUM_MSGS |
NUMBER |
| CNUM_MSGS |
NUMBER |
| TOTAL_DEQUEUED_MSG |
NUMBER |
| TOTAL_SPILLED_MSG |
NUMBER |
Version 2
| Column Name |
Data Type |
| ADDR |
RAW(4) |
| INDX |
NUMBER |
| INST_ID |
NUMBER |
| QUEUE_ID |
NUMBER |
| SUBSCRIBER_ID |
NUMBER |
| SUBSCRIBER_NAME |
VARCHAR2(30) |
| SUBSCRIBER_ADDRESS |
VARCHAR2(1024) |
| PROTOCOL |
NUMBER |
| SUBSCRIBER_TYPE |
VARCHAR2(30) |
| LAST_BROWSED_SEQ |
NUMBER |
| LAST_BROWSED_NUM |
NUMBER |
| LAST_DEQUEUED_SEQ |
NUMBER |
| LAST_DEQUEUED_NUM |
NUMBER |
| CURRENT_ENQ_SEQ |
NUMBER |
| NUM_MSGS |
NUMBER |
| CNUM_MSGS |
NUMBER |
| TOTAL_DEQUEUED_MSG |
NUMBER |
| TOTAL_SPILLED_MSG |
NUMBER |
| EXPIRED_MSGS |
NUMBER |
Version 3
| Column Name |
Data Type |
| ADDR |
RAW(4) |
| INDX |
NUMBER |
| INST_ID |
NUMBER |
| QUEUE_ID |
NUMBER |
| SUBSCRIBER_ID |
NUMBER |
| SUBSCRIBER_NAME |
VARCHAR2(30) |
| SUBSCRIBER_ADDRESS |
VARCHAR2(1024) |
| PROTOCOL |
NUMBER |
| SUBSCRIBER_TYPE |
VARCHAR2(30) |
| LAST_BROWSED_SEQ |
NUMBER |
| LAST_BROWSED_NUM |
NUMBER |
| LAST_DEQUEUED_SEQ |
NUMBER |
| LAST_DEQUEUED_NUM |
NUMBER |
| CURRENT_ENQ_SEQ |
NUMBER |
| NUM_MSGS |
NUMBER |
| CNUM_MSGS |
NUMBER |
| TOTAL_DEQUEUED_MSG |
NUMBER |
| TOTAL_SPILLED_MSG |
NUMBER |
| EXPIRED_MSGS |
NUMBER |
| MESSAGE_LAG |
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
Version 3
Version 3 of this fixed view does not have any indexes
|
