select OWNER, ATTR_TYPE_NAME , TYPE_NAME,
ATTR_NAME from dba_type_attrs
SEE CODE DEPOT FOR FULL SCRIPT
This view describes the methods of the
object types accessible in the database.
This view describes the object types
accessible in the database.
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
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
COL SENDER_NAME HEADING 'Capture|Process'
COL SENDER_ADDRESS HEADING 'Sender Queue'
COL QUEUE_NAME HEADING 'Queue Name' FORMAT
COL CNUM_MSGS HEADING 'Number|of
LCRs|Enqueued' FORMAT 99999999
COL LAST_ENQUEUED_MSG HEADING
'Last|Enqueued|LCR' FORMAT 99999999