This chapter lists the static data dictionary views and dynamic performance views related to Streams. You can use these views to monitor your Streams environment.
This chapter contains these topics:
Note:
The Streams tool in the Oracle Enterprise Manager Console is also an excellent way to monitor a Streams environment. See the online help for the Streams tool for more information.See Also:
Oracle Database Reference for information about the data dictionary views described in this chapter
Oracle Streams Replication Administrator's Guide for information about monitoring a Streams replication environment
Table 19-1 lists the Streams static data dictionary views.
Table 19-1 Streams Static Data Dictionary Views
ALL_ Views | DBA_ Views | USER_ Views |
---|---|---|
N/A |
||
N/A |
||
N/A |
||
N/A |
||
N/A |
||
N/A |
||
N/A |
N/A |
|
N/A |
N/A |
|
N/A |
N/A |
|
N/A |
||
N/A |
N/A |
|
N/A |
||
N/A |
||
N/A |
N/A |
|
N/A |
||
N/A |
N/A |
|
N/A |
||
N/A |
||
N/A |
||
N/A |
||
N/A |
||
N/A |
||
N/A |
N/A |
|
N/A |
N/A |
|
N/A |
N/A |
|
N/A |
||
N/A |
N/A |
|
N/A |
N/A |
|
N/A |
N/A |
|
N/A |
N/A |
|
N/A |
||
N/A |
||
N/A |
||
N/A |
||
N/A |
N/A |
|
N/A |
N/A |
|
N/A |
N/A |
|
N/A |
||
N/A |
||
N/A |
||
N/A |
||
N/A |
N/A |
|
N/A |
The Streams dynamic performance views are:
Note:
When monitoring a Real Application Clusters (RAC) database, use the GV$ versions of the dynamic performance views.
To collect elapsed time statistics in these dynamic performance views, set the TIMED_STATISTICS
initialization parameter to true
.