|
Welcome
Seminars
Consultancy
Presentations
Diagnostics
Internals
Acknowledgements
|
Fixed View: X$BUFFERED_QUEUES
Versions
| Oracle Version |
X$ Version |
| 10.1.0.3.0 |
1 |
| 10.2.0.1.0 |
3 |
| 11.1.0.6.0 |
3 |
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) |
| NUM_MSGS |
NUMBER |
| STARTUP_TIME |
DATE |
| SPILL_MSGS |
NUMBER |
| CNUM_MSGS |
NUMBER |
| CSPILL_MSGS |
NUMBER |
Version 3
| Column Name |
Data Type |
| ADDR |
RAW(4) |
| INDX |
NUMBER |
| INST_ID |
NUMBER |
| QUEUE_ID |
NUMBER |
| QUEUE_SCHEMA |
VARCHAR2(30) |
| QUEUE_NAME |
VARCHAR2(30) |
| NUM_MSGS |
NUMBER |
| STARTUP_TIME |
DATE |
| SPILL_MSGS |
NUMBER |
| CNUM_MSGS |
NUMBER |
| CSPILL_MSGS |
NUMBER |
| EXPIRED_MSGS |
NUMBER |
| BUFFER_MESSAGE_TYPE |
VARCHAR2(30) |
| FLAGS |
NUMBER |
| NONSPILLED_NUM_RANGE |
NUMBER |
| NONSPILLED_MSGS |
NUMBER |
| QUEUE_SPARSITY |
NUMBER |
Indexes
Version 1
Version 1 of this fixed view does not have any indexes
Version 3
Version 3 of this fixed view does not have any indexes
|
