22 Monitoring an Oracle Streams Environment
This chapter lists the static data dictionary views and dynamic performance views related to Oracle Streams. You can use these views to monitor your Oracle Streams environment.
The following sections contain data dictionary views for monitoring an Oracle Streams environment:
Note:
The Oracle Streams tool in Oracle Enterprise Manager Cloud Control is also an excellent way to monitor an Oracle Streams environment. See the online help for the Oracle Streams tool for more information.
See Also:
-
Oracle Database Reference for information about the data dictionary views described in this chapter
22.1 Summary of Oracle Streams Static Data Dictionary Views
Table 22-1 lists the Oracle Streams static data dictionary views.
Table 22-1 Oracle 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 |
|
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 |
22.2 Summary of Oracle Streams Dynamic Performance Views
The Oracle Streams dynamic performance views are:
Note:
-
When monitoring an Oracle Real Application Clusters (Oracle 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 toTRUE
.