Database Reference
In-Depth Information
Figure 10-2.
General properties of
open_cursor_pct
metric extension
Set the Target Type option to Database Instance so the metric can be deployed on a single-instance database as
well as on each instance of a RAC database. If you were to select the metric from a real table or to monitor a global
condition such as the number of messages in a queue table, you would set the Target Type to Cluster Database instead
of each RAC database instance. Set the Name property to
open_cursors_pct
. This is the name used by EM internally,
and you would use it later if you needed to extract information from the repository—for example, writing a SQL
statement for a custom report. Choose SQL as the Adapter and select a collection interval of 1 minute and an upload
interval of 1 (indicating an upload on each collection). I recommend that you choose collection intervals carefully and
avoid collecting metrics more frequently than 5-15 minutes. You should set the interval below 5 minutes for only a
