|
Welcome
Seminars
Consultancy
Calendar
Presentations
Diagnostics
Internals
References
Acknowledgements
|
Fixed View: X$BUFFERED_PUBLISHERS
Versions
| Oracle Version |
X$ Version |
| 10.1.0.3.0 |
1 |
| 10.2.0.1.0 |
2 |
| 11.1.0.6.0 |
2 |
Columns
Version 1
| Column Name |
Data Type |
| ADDR |
RAW(4) |
| INDX |
NUMBER |
| INST_ID |
NUMBER |
| QUEUE_ID |
NUMBER |
| QUEUE_SCHEMA |
VARCHAR2(30) |
| QUEUE_NAME |
VARCHAR2(30) |
| SENDER_NAME |
VARCHAR2(30) |
| SENDER_ADDRESS |
VARCHAR2(1024) |
| SENDER_PROTOCOL |
NUMBER |
| NUM_MSGS |
NUMBER |
| CNUM_MSGS |
NUMBER |
| TOTAL_DEQUEUED_MSGS |
NUMBER |
| LAST_DEQUEUED_MSG |
NUMBER |
| LAST_ENQUEUED_MSG |
NUMBER |
| TOTAL_SEEN_MSGS |
NUMBER |
| TOTAL_DELETED_MSGS |
NUMBER |
| PUBLISHER_FLAGS |
NUMBER |
Version 2
| Column Name |
Data Type |
| ADDR |
RAW(4) |
| INDX |
NUMBER |
| INST_ID |
NUMBER |
| QUEUE_ID |
NUMBER |
| QUEUE_SCHEMA |
VARCHAR2(30) |
| QUEUE_NAME |
VARCHAR2(30) |
| SENDER_NAME |
VARCHAR2(30) |
| SENDER_ADDRESS |
VARCHAR2(1024) |
| SENDER_PROTOCOL |
NUMBER |
| NUM_MSGS |
NUMBER |
| CNUM_MSGS |
NUMBER |
| TOTAL_DEQUEUED_MSGS |
NUMBER |
| LAST_DEQUEUED_MSG |
NUMBER |
| LAST_ENQUEUED_MSG |
NUMBER |
| TOTAL_SEEN_MSGS |
NUMBER |
| TOTAL_DELETED_MSGS |
NUMBER |
| PUBLISHER_FLAGS |
NUMBER |
| UNBROWSED_MSGS |
NUMBER |
| OVERSPILLED_MSGS |
NUMBER |
| MEMORY_USAGE |
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
|
