Skip To Content

Register Oracle databases

You can register databases and geodatabases in Oracle to collect metrics and attribute information.

Prerequisites for monitoring

The following prerequisites are necessary for monitoring databases and geodatabases in Oracle:

  • ArcGIS Monitor Agent must be installed on a machine that has access to the Oracle machine and must be registered with ArcGIS Monitor Server.

    When access to the Oracle machine is available, it is recommended that you install Monitor Agent on that machine to collect operating system metrics.

  • The database instance must be running Oracle version 12.1 or later.
    Note:

    Client drivers are included with the Monitor software.

  • When Monitor Agent is not installed on the Oracle machine, the firewall must allow communication between Oracle and the ArcGIS Monitor machine on port 1521.
    Note:

    If Oracle is configured to run on a different port, communication must be allowed on that port instead.

  • The Oracle user account that you use to register the database for monitoring must have the following read permissions to collect attribute and metric data:
    • SDE system tables (if applicable)
    • v$instance
    • v$session
    • v$sesstat
    • v$sga
    • v$statname
    • v$sysmetric
    • DUAL

Register databases for monitoring

You must be assigned the Administrator or Manager role to register components.

To register databases and geodatabases in Oracle, complete the following steps:

  1. Access ArcGIS Monitor if necessary.

    The Home page appears.

  2. Click Monitoring.

    The Monitoring page appears. Registered components are listed alphabetically by component name.

  3. Click Register component.

    The Register component wizard appears.

    Note:

    If you don't have sufficient privileges, Register component is not available.

  4. Choose the Monitor Agent machine where the component is installed.

    The Component type page appears.

  5. Under Database, choose Oracle and click Next.

    The Component details page appears.

  6. Provide a name for the component in the Component name text box.
  7. Optionally, provide a description for the component in the Description text box.
  8. Optionally, click Apply Labels Apply labels and choose the labels that you want to apply to the component.
    Tip:

    Provide the name of a label in the Enter label name text box to search for a specific label. If the label doesn't exist, click Create new label to add the label and apply it to the component.

  9. Click Next.

    The Connection page appears.

  10. Type the fully qualified domain name or IP address and port number of the database instance that you want to register in the Address text box.
    Tip:

    The default port number for Oracle is 1521.

  11. Type the service name of the database that you want to register in the Service name text box.
  12. Provide the credentials for the database in the Username and Password text boxes.
  13. Click Register component.

    The component is added to the list of monitored components on the Monitoring page.

Once a component is registered, you can configure alert rules and add the component to collections.

Note:

Other component types, such as the enterprise GIS implementation's underlying hardware infrastructure and ArcGIS software, must be registered individually to enable monitoring.

Observers

The following table describes the observers that are responsible for collecting attribute and metric data:

Observer nameDescription

Inventory

The Inventory observer scans for changes and manages attribute data across the registered Oracle database. It also detects enterprise geodatabase schemas to enable related metrics.

The default interval for this observer is 10 minutes; however, you can configure it to run at longer intervals since changes to the database configuration are typically infrequent.

Metrics

The Metrics observer collects metric data across the registered Oracle database. If an enterprise geodatabase schema is not detected by the Inventory observer, geodatabase-related metrics are not collected.

The default interval for this observer is 1 minute; however, you can configure it to run at longer intervals since significant database variations are typically infrequent.

Collected attributes

The subsections below describe the attributes that are collected for registered databases and geodatabases in Oracle.

Database attributes

The following table lists the attributes that are collected for databases in Oracle:

Attribute nameDescriptionData type

Memory total

The total amount of system global area (SGA) memory for the database instance

Float

Started at

The last start time of the database instance

Datetime

UTC offset

The UTC time zone offset for the database instance

Integer

Version

The software version of the Oracle instance

String

Geodatabase attributes

The following table lists the attributes that are collected for geodatabases in Oracle:

Attribute nameDescriptionData type

Geodatabase version

The version of the enterprise geodatabase.

String

Collected metrics

The subsections below describe the metrics that are collected for registered databases and geodatabases in Oracle.

Database metrics

The following table lists the metrics that are collected for databases in Oracle:

Metric nameDescriptionData typeUnit

Cache Hit

The percentage of requests served from the cache, as opposed to requests served from disk

Float

Percent

Connectivity

The agent's ability to successfully connect to the component.

Float

Percent

Database Sessions

The number of open sessions in the database

Float

Total

Open Cursors

The number of open cursors in the database

Float

Total

Geodatabase metrics

The following table lists the metrics that are collected for geodatabases in Oracle:

Metric nameDescriptionData typeUnit

GDB Branch Version Conflicts

The total number of branch version conflicts in the geodatabase

Float

Total

GDB Branch Version Locks

The total number of locks on branch versions in the geodatabase

Float

Total

GDB Branch Versions

The total number of branch versions in the geodatabase

Float

Total

GDB Connections

The total number of active connections to the geodatabase

Float

Total

GDB Connections - editors

The total number of active editor connections to the geodatabase

Float

Total

GDB Connections - viewers

The total number of active viewer connections to the geodatabase

Float

Total

GDB Default Version Depth

The depth in the state tree of the default version

Float

Total

GDB Shared Locks

The total number of shared table locks in the geodatabase

Float

Total

GDB State Lineages

The total number of edits in the geodatabase for datasets that use traditional versioning

Float

Total

GDB Version States

The total number of states in the geodatabase for datasets that use traditional versioning

Float

Total

GDB Versions

The total number of versions in the geodatabase that use traditional versioning

Float

Total

Default alert rules

The following table lists the default alert rules that are configured for databases in Oracle:

Metric nameAggregationOperatorInfo thresholdWarning thresholdCritical thresholdSamples

Cache Hit

Average

Is less than

90

3

Connectivity

Average

Is less than

100

2

Note:

The default alert rules in the table above are the rules that are configured for components when Monitor is first deployed. If your Monitor administrator has configured default alert rules for the Monitor deployment, the values for the rules above may vary.

Related topics