Database Reference
In-Depth Information
Figure 9-44.
Managing optimizer statistics in the EM12c Performance console
Each of the links accesses a different area for managing database statistics. This includes operational tasks.
From a lower section, you can access object-level and global-level statistics, along with scheduling and automating.
Cloud Control SQL History
The Cloud Control SQL History, unlike history from other SQL, includes SQL executed by EM12c for managing and
monitoring the database environment. The view provides not just
SQL_TEXT
, but the start time, the duration and
the URL (see Figure
9-45
). The URL is extremely valuable, as it is descriptive enough to inform you which EM12c
feature was responsible for the SQL executed.
Figure 9-45.
Information regarding a SQL statement from the cloud control that was issued by the SQL Monitor
in EM12c
