Manage Oracle Database extensions

Dynatrace provides you with a framework that you can use to extend your application observability into data acquired directly from your Oracle Database layer, so that you can monitor how database server tasks impact your app.

First check our Software intelligence hub to see if the Dynatrace-provided Oracle Database extension satisfies your requirements. If this is not the case, you can build your own Dynatrace Oracle Database extension.

Before you begin

1. Decide which Oracle Database server you want to monitor. Oracle Database extensions support:
   • Oracle standalone servers
   • Oracle Multitenant (CDB/PDB)
   • Oracle Database versions 12c-21c
2. Designate an ActiveGate group or groups that will remotely connect to your Oracle Database server to pull data. All ActiveGates in each designated group need to be able to connect to your Oracle Database server.
3. Create a dedicated user account used for monitoring and grant him the following roles:

• CREATE_SESSION

• SELECT_CATALOG_ROLE

  Instead of SELECT_CATALOG_ROLE you can also grant this user a SELECT permission on following performance views:

  • V$Metric
  • V$MetricGroup
  • V$SysStat
  • V$System_Event
  • V$System_Wait_Class
  • V$Parameter
  • V$PGAStat
  • V$SGAStat
  • V$LibraryCache
  • V$Sys_Time_Model
  • V$Session
  • V$Tablespace
  • DBA_Data_Files
  • DBA_Lmt_Free_Space
  • DBA_Tablespaces
  • DBA_Temp_Free_Space

Manage Oracle SQL extensions

Dynatrace Hub provides a unified workflow to enable and manage extensions that will ingest Oracle Database data into your Dynatrace environment.

1. From the Dynatrace menu, go to Dynatrace Hub.
2. Search for an Oracle Database extension. You can use the Oracle SQL keyword to filter the Hub tiles.
3. Select Add to environment. This creates the environment configuration for your extension, thus enabling the extension in your environment.
4. Select Add monitoring configuration.

After that, perform the following steps.

Accept Oracle JDBC driver redistribution license

Define endpoints

ActiveGate group

Activate extension

Accept Oracle JDBC driver redistribution license

An Oracle Database extension requires that you accept the Dynatrace redistribution license agreement for Oracle JDBC Driver.

Define endpoints

Select Add Oracle endpoint to define the Oracle Database servers from which you want to pull data. You can define up to 100 endpoints. Provide the following connection details:

• Host
• Port
• Database identifier, either Service Name or SID.
• Authentication credentials. Note that only basic authentication is supported. Authentication details passed to Dynatrace when activating monitoring configuration are obfuscated and it's impossible to retrieve them.

When done, select Next step

ActiveGate group

Select the ActiveGate group to determine which ActiveGates will run the extension. When done, select Next step.

Activate extension

Provide final configuration details.

• Description
  Text explaining details of this particular monitoring configuration. When troubleshooting monitoring, this can give your teams details of this particular monitoring configuration.
• Feature sets
  In highly segmented networks, feature sets can reflect the segments of your environment. You can use them to limit your monitoring to particular segments. Feature sets are predefined for each extension.

When done, select Activate.

Monitoring configuration as JSON

The extension activation wizard contains a dynamically updated JSON payload with your monitoring configuration. See Extensions 2.0 lifecycle to learn how to use it to activate an extension using the Dynatrace API.