 |
|
Oracle Tips by Burleson |
Oracle Streams
Chapter 7 -
Monitoring and Troubleshooting Oracle Streams
dba_capture_extra_attributes
COLUMN CAPTURE_NAME HEADING 'Capture Process'
FORMAT A20
COLUMN ATTRIBUTE_NAME HEADING 'Attribute Name'
FORMAT A15
COLUMN INCLUDE HEADING 'Include Attribute in
LCRs?' FORMAT A30
SELECT CAPTURE_NAME, ATTRIBUTE_NAME, INCLUDE,
ROW_ATTRIBUTE, DDL_ATTRIBUTE
FROM DBA_CAPTURE_EXTRA_ATTRIBUTES
ORDER BY CAPTURE_NAME
/
dba_capture_parameters
This view displays information about the
parameters for all the Capture processes in the database. The
PARAMETER and VALUE column pair show the name and the value for that
parameter. When any additional parameters are set to the Capture
process, the capture behavior can be influenced.
COLUMN parameter FORMAT A20
COLUMN value FORMAT A20
COLUMN set_by_user FORMAT A20
SELECT CAPTURE_NAME, parameter,
value, set_by_user
FROM DBA_CAPTURE_PARAMETERS
/
The above text is
an excerpt from:
Oracle Streams
High Speed Replication and Data
Sharing
ISBN 0-9745993-5-2
by Madhu Tumma
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
