dba_type_attrs
select OWNER, ATTR_TYPE_NAME , TYPE_NAME,
ATTR_NAME from dba_type_attrs
SEE CODE DEPOT FOR FULL SCRIPT
dba_type_methods
This view describes the methods of the
object types accessible in the database.
dba_types
This view describes the object types
accessible in the database.
Queue and
Propagation Related Views
There are many dynamic and static views
that help to look at the queue and propagation processes. Figure
7.4 shows such views.
Figure 7.4 Queue and Propagation Related
static and dynamic views
v$buffered_publishers
This view displays information about all
buffered publishers in the instance. There is one row per queue
per sender. The values are reset to zero when the database, or
instance in a RAC environment, restarts. Therefore, the
statistics should be used carefully as they may not give a total
picture.
COL SENDER_NAME HEADING 'Capture|Process'
FORMAT A20
COL SENDER_ADDRESS HEADING 'Sender Queue'
FORMAT A25
COL QUEUE_NAME HEADING 'Queue Name' FORMAT
A15
COL CNUM_MSGS HEADING 'Number|of
LCRs|Enqueued' FORMAT 99999999
COL LAST_ENQUEUED_MSG HEADING
'Last|Enqueued|LCR' FORMAT 99999999
