Contains entity definitions for Oracle Database entities stored in Smartscape on Grail. All Oracle entity types are prefixed with DB_* and end in _ORACLE.
Get all ORACLE entities.
smartscapeNodes "*_ORACLE"
Smartscape node name: group_name
Smartscape node type: DB_ASM_DISK_GROUP_ORACLE
An Oracle Database ASM disk group entity. Represents an Automatic Storage Management disk group.
Fetch all Oracle Database ASM disk group entities.
smartscapeNodes DB_ASM_DISK_GROUP_ORACLE
Get ASM disk groups and their parent entities.
smartscapeEdges "belongs_to"| filter matchesValue(source_type, "DB_ASM_DISK_GROUP_ORACLE") and (matchesValue(target_type, "DB_CLUSTER_ORACLE") or matchesValue(target_type, "DB_INSTANCE_ORACLE"))| fields disk_group_name=getNodeName(source_id), parent_name=getNodeName(target_id), target_type
The ID is calculated based on the following fields in the defined order: db.connection_details, group_name
The following base fields are used for all entities.
| Attribute | Type | Description | Examples |
|---|---|---|---|
| smartscapeId | stableA Smartscape ID consists of two components: an UPPER_CASE entity type and a random 16-character hexadecimal unique identifier, separated by a dash. Use Smartscape conversion functions when working with strings that represent Smartscape IDs. |
|
| string | deprecatedThe entity ID that was used in the classic entity store. This ID is present in old monitoring data. Not all entities have this ID, and it is not generated for new entities. Use the |
|
| string | stableThe entity name. |
|
| string | stableThe entity type. UPPER_SNAKE_CASE string that represents the type of the entity. |
|
| record | stableA consolidated record that aggregates all tag values originating from different contexts. Each nested field within tags represents a specific key (for example, |
|
| timeframe | stableThe lifetime of the entity. This is a record with two nested fields: |
|
| record | stableProvides access to static edges pointing to other entities. In this record each nested field represents a relationship type and target type, and the value is an array of target smartscape IDs. This field is hidden by default but can be added using the fieldsAdd command. |
|
| string[] | resource stableThe security contexts associated with the entity. For Smartscape entities, this field is always an array.Tags: |
|
Fields common to all entities within the databases model.
| Attribute | Type | Description | Examples |
|---|---|---|---|
| ipAddress | experimentalIP address of the listener to which Dynatrace is connected. |
|
| string | experimentalHostname of the listener Dynatrace is connected to. |
|
| string | experimentalPort of the listener Dynatrace is connected to. |
|
| string | experimentalListener connection details in the form |
|
| string | experimentalAn identifier for the database management system (DBMS) product being used. See below for a list of well-known identifiers. |
|
db.system has the following list of well-known values. If one of them applies, then the respective value MUST be used, otherwise a custom value MAY be used.
| Value | Description | Display name |
|---|---|---|
| Adabas (Adaptable Database System) | Adabas |
| Amazon DocumentDB | DocumentDB |
| Amazon Aurora MySQL | Aurora MySQL |
| Amazon Aurora PostgreSQL | Aurora PostgreSQL |
| InterSystems Caché | InterSystems Caché |
| Apache Cassandra | Cassandra |
| ClickHouse | ClickHouse |
| Cloudscape | Cloudscape |
| CockroachDB | CockroachDB |
| ColdFusion IMQ | ColdFusion IMQ |
| Microsoft Azure Cosmos DB | Cosmos DB |
| Couchbase | Couchbase |
| CouchDB | CouchDB |
| Databricks Data Platform | Databricks Data Platform |
| IBM Db2 | IBM Db2 |
| Apache Derby | Derby |
| IBM DL/I | IBM DL/I |
| Amazon DynamoDB | DynamoDB |
| EnterpriseDB | EnterpriseDB |
| Elasticsearch | Elasticsearch |
| FileMaker | FileMaker |
| Firebird | Firebird |
| FirstSQL | FirstSQL |
| Apache Geode | Geode |
| H2 | H2 |
| SAP HANA | SAP HANA |
| Apache HBase | HBase |
| Apache Hive | Hive |
| HyperSQL DataBase | HSQLDB |
| Informix | Informix |
| Ingres | Ingres |
| InstantDB | InstantDB |
| InterBase | InterBase |
| Amazon Keyspaces for Apache Cassandra | Keyspaces |
| MariaDB | MariaDB |
| SAP MaxDB | SAP MaxDB |
| Memcached | Memcached |
| MongoDB | MongoDB |
| Microsoft SQL Server | SQL Server |
| Microsoft SQL Server Compact | SQL Server Compact |
| MySQL | MySQL |
| Neo4j | Neo4j |
| Amazon Neptune | Neptune |
| Netezza | Netezza |
| OpenSearch | OpenSearch |
| Oracle Database | Oracle |
| Some other SQL database. Fallback only. See notes. | Other SQL |
| Pervasive PSQL | Pervasive PSQL |
| Apache Phoenix | Apache Phoenix |
| PointBase | PointBase |
| PostgreSQL | PostgreSQL |
| Progress Database | Progress |
| Redis | Redis |
| Amazon Redshift | Redshift |
| Snowflake Data Platform | Snowflake Data Platform |
| Cloud Spanner | Cloud Spanner |
| SQLite | SQLite |
| Sybase | Sybase |
| Teradata | Teradata |
| Valkey | Valkey |
| Vertica | Vertica |
Fields that are common across all DB_INSTANCE_* type nodes.
| Attribute | Type | Description | Examples |
|---|---|---|---|
| string | experimentalName of the database instance. |
|
| string | experimentalVersion of the database instance as reported by the database vendor. |
|
Specific attributes of Oracle Database ASM disk group entity.
| Attribute | Type | Description | Examples |
|---|---|---|---|
| string | experimentalName of the ASM disk group. |
|
| string | experimentalState of the ASM disk group. |
|
| Type | Target type | Kind | Description |
|---|---|---|---|
|
| static | stableThis is similar to an aggregation in UML. It is a many-to-many relationship without existential properties (the destination is not composed of the sources). |
|
| static | stableThis is similar to an aggregation in UML. It is a many-to-many relationship without existential properties (the destination is not composed of the sources). |
Smartscape node name: db.connection_details
Smartscape node type: DB_CLUSTER_ORACLE
An Oracle Database RAC cluster entity. Represents a Real Application Cluster (RAC) setup.
Fetch all Oracle Database cluster entities.
smartscapeNodes DB_CLUSTER_ORACLE
The ID is calculated based on the following fields in the defined order: db.connection_details
The following base fields are used for all entities.
| Attribute | Type | Description | Examples |
|---|---|---|---|
| smartscapeId | stableA Smartscape ID consists of two components: an UPPER_CASE entity type and a random 16-character hexadecimal unique identifier, separated by a dash. Use Smartscape conversion functions when working with strings that represent Smartscape IDs. |
|
| string | deprecatedThe entity ID that was used in the classic entity store. This ID is present in old monitoring data. Not all entities have this ID, and it is not generated for new entities. Use the |
|
| string | stableThe entity name. |
|
| string | stableThe entity type. UPPER_SNAKE_CASE string that represents the type of the entity. |
|
| record | stableA consolidated record that aggregates all tag values originating from different contexts. Each nested field within tags represents a specific key (for example, |
|
| timeframe | stableThe lifetime of the entity. This is a record with two nested fields: |
|
| record | stableProvides access to static edges pointing to other entities. In this record each nested field represents a relationship type and target type, and the value is an array of target smartscape IDs. This field is hidden by default but can be added using the fieldsAdd command. |
|
| string[] | resource stableThe security contexts associated with the entity. For Smartscape entities, this field is always an array.Tags: |
|
Fields common to all entities within the databases model.
| Attribute | Type | Description | Examples |
|---|---|---|---|
| ipAddress | experimentalIP address of the listener to which Dynatrace is connected. |
|
| string | experimentalHostname of the listener Dynatrace is connected to. |
|
| string | experimentalPort of the listener Dynatrace is connected to. |
|
| string | experimentalListener connection details in the form |
|
| string | experimentalAn identifier for the database management system (DBMS) product being used. See below for a list of well-known identifiers. |
|
db.system has the following list of well-known values. If one of them applies, then the respective value MUST be used, otherwise a custom value MAY be used.
| Value | Description | Display name |
|---|---|---|
| Adabas (Adaptable Database System) | Adabas |
| Amazon DocumentDB | DocumentDB |
| Amazon Aurora MySQL | Aurora MySQL |
| Amazon Aurora PostgreSQL | Aurora PostgreSQL |
| InterSystems Caché | InterSystems Caché |
| Apache Cassandra | Cassandra |
| ClickHouse | ClickHouse |
| Cloudscape | Cloudscape |
| CockroachDB | CockroachDB |
| ColdFusion IMQ | ColdFusion IMQ |
| Microsoft Azure Cosmos DB | Cosmos DB |
| Couchbase | Couchbase |
| CouchDB | CouchDB |
| Databricks Data Platform | Databricks Data Platform |
| IBM Db2 | IBM Db2 |
| Apache Derby | Derby |
| IBM DL/I | IBM DL/I |
| Amazon DynamoDB | DynamoDB |
| EnterpriseDB | EnterpriseDB |
| Elasticsearch | Elasticsearch |
| FileMaker | FileMaker |
| Firebird | Firebird |
| FirstSQL | FirstSQL |
| Apache Geode | Geode |
| H2 | H2 |
| SAP HANA | SAP HANA |
| Apache HBase | HBase |
| Apache Hive | Hive |
| HyperSQL DataBase | HSQLDB |
| Informix | Informix |
| Ingres | Ingres |
| InstantDB | InstantDB |
| InterBase | InterBase |
| Amazon Keyspaces for Apache Cassandra | Keyspaces |
| MariaDB | MariaDB |
| SAP MaxDB | SAP MaxDB |
| Memcached | Memcached |
| MongoDB | MongoDB |
| Microsoft SQL Server | SQL Server |
| Microsoft SQL Server Compact | SQL Server Compact |
| MySQL | MySQL |
| Neo4j | Neo4j |
| Amazon Neptune | Neptune |
| Netezza | Netezza |
| OpenSearch | OpenSearch |
| Oracle Database | Oracle |
| Some other SQL database. Fallback only. See notes. | Other SQL |
| Pervasive PSQL | Pervasive PSQL |
| Apache Phoenix | Apache Phoenix |
| PointBase | PointBase |
| PostgreSQL | PostgreSQL |
| Progress Database | Progress |
| Redis | Redis |
| Amazon Redshift | Redshift |
| Snowflake Data Platform | Snowflake Data Platform |
| Cloud Spanner | Cloud Spanner |
| SQLite | SQLite |
| Sybase | Sybase |
| Teradata | Teradata |
| Valkey | Valkey |
| Vertica | Vertica |
Specific attributes of Oracle Database cluster entity.
| Attribute | Type | Description | Examples |
|---|---|---|---|
| string | experimentalArchive log mode. |
|
| string | experimentalCurrent role of the database. |
|
| string | experimentalIndicates whether flashback is ON. |
|
| string | experimentalIndicates whether Oracle Dataguard is enabled. |
|
Smartscape node name: db.database.name
Smartscape node type: DB_DATABASE_ORACLE
A Oracle Database database entity.
Fetch all Oracle Database database entities.
smartscapeNodes DB_DATABASE_ORACLE
Get databases and corresponding instances.
smartscapeEdges "runs_on"| filter matchesValue(source_type, "DB_DATABASE_ORACLE") and matchesValue(target_type, "DB_INSTANCE_ORACLE")| fields database_name=getNodeName(source_id), instance_name=getNodeName(target_id)
The ID is calculated based on the following fields in the defined order: db.connection_details, db.database.name
The following base fields are used for all entities.
| Attribute | Type | Description | Examples |
|---|---|---|---|
| smartscapeId | stableA Smartscape ID consists of two components: an UPPER_CASE entity type and a random 16-character hexadecimal unique identifier, separated by a dash. Use Smartscape conversion functions when working with strings that represent Smartscape IDs. |
|
| string | deprecatedThe entity ID that was used in the classic entity store. This ID is present in old monitoring data. Not all entities have this ID, and it is not generated for new entities. Use the |
|
| string | stableThe entity name. |
|
| string | stableThe entity type. UPPER_SNAKE_CASE string that represents the type of the entity. |
|
| record | stableA consolidated record that aggregates all tag values originating from different contexts. Each nested field within tags represents a specific key (for example, |
|
| timeframe | stableThe lifetime of the entity. This is a record with two nested fields: |
|
| record | stableProvides access to static edges pointing to other entities. In this record each nested field represents a relationship type and target type, and the value is an array of target smartscape IDs. This field is hidden by default but can be added using the fieldsAdd command. |
|
| string[] | resource stableThe security contexts associated with the entity. For Smartscape entities, this field is always an array.Tags: |
|
Fields common to all entities within the databases model.
| Attribute | Type | Description | Examples |
|---|---|---|---|
| ipAddress | experimentalIP address of the listener to which Dynatrace is connected. |
|
| string | experimentalHostname of the listener Dynatrace is connected to. |
|
| string | experimentalPort of the listener Dynatrace is connected to. |
|
| string | experimentalListener connection details in the form |
|
| string | experimentalAn identifier for the database management system (DBMS) product being used. See below for a list of well-known identifiers. |
|
db.system has the following list of well-known values. If one of them applies, then the respective value MUST be used, otherwise a custom value MAY be used.
| Value | Description | Display name |
|---|---|---|
| Adabas (Adaptable Database System) | Adabas |
| Amazon DocumentDB | DocumentDB |
| Amazon Aurora MySQL | Aurora MySQL |
| Amazon Aurora PostgreSQL | Aurora PostgreSQL |
| InterSystems Caché | InterSystems Caché |
| Apache Cassandra | Cassandra |
| ClickHouse | ClickHouse |
| Cloudscape | Cloudscape |
| CockroachDB | CockroachDB |
| ColdFusion IMQ | ColdFusion IMQ |
| Microsoft Azure Cosmos DB | Cosmos DB |
| Couchbase | Couchbase |
| CouchDB | CouchDB |
| Databricks Data Platform | Databricks Data Platform |
| IBM Db2 | IBM Db2 |
| Apache Derby | Derby |
| IBM DL/I | IBM DL/I |
| Amazon DynamoDB | DynamoDB |
| EnterpriseDB | EnterpriseDB |
| Elasticsearch | Elasticsearch |
| FileMaker | FileMaker |
| Firebird | Firebird |
| FirstSQL | FirstSQL |
| Apache Geode | Geode |
| H2 | H2 |
| SAP HANA | SAP HANA |
| Apache HBase | HBase |
| Apache Hive | Hive |
| HyperSQL DataBase | HSQLDB |
| Informix | Informix |
| Ingres | Ingres |
| InstantDB | InstantDB |
| InterBase | InterBase |
| Amazon Keyspaces for Apache Cassandra | Keyspaces |
| MariaDB | MariaDB |
| SAP MaxDB | SAP MaxDB |
| Memcached | Memcached |
| MongoDB | MongoDB |
| Microsoft SQL Server | SQL Server |
| Microsoft SQL Server Compact | SQL Server Compact |
| MySQL | MySQL |
| Neo4j | Neo4j |
| Amazon Neptune | Neptune |
| Netezza | Netezza |
| OpenSearch | OpenSearch |
| Oracle Database | Oracle |
| Some other SQL database. Fallback only. See notes. | Other SQL |
| Pervasive PSQL | Pervasive PSQL |
| Apache Phoenix | Apache Phoenix |
| PointBase | PointBase |
| PostgreSQL | PostgreSQL |
| Progress Database | Progress |
| Redis | Redis |
| Amazon Redshift | Redshift |
| Snowflake Data Platform | Snowflake Data Platform |
| Cloud Spanner | Cloud Spanner |
| SQLite | SQLite |
| Sybase | Sybase |
| Teradata | Teradata |
| Valkey | Valkey |
| Vertica | Vertica |
Fields that are common across all DB_DATABASE_* type nodes.
| Attribute | Type | Description | Examples |
|---|---|---|---|
| string | experimentalName of the database. |
|
Specific attributes for all Oracle Database entities.
| Attribute | Type | Description | Examples |
|---|---|---|---|
| string | experimentalDatabase open mode. |
|
Specific attributes of Oracle Database database entity.
| Attribute | Type | Description | Examples |
|---|---|---|---|
| string | experimentalName of the CDB this PDB corresponds to. |
|
| string | experimentalIndicates whether only users possessing RESTRICTED SESSION privilege can connect to the PDB. |
|
| string | experimentalIndicates what type of user last changed the PDB. |
|
| string | experimentalDate and time when the database was last opened. |
|
| Type | Target type | Kind | Description |
|---|---|---|---|
|
| static | stableDefines a "vertical" relation of an entity running on some other entity. It does not imply any composition or aggregation but only a looser association between the entities. One entity can run on multiple other entities. Examples: Service running on a POD, a CONTAINER or a HOST. |
|
| static | stableDefines a "vertical" relation of an entity running on some other entity. It does not imply any composition or aggregation but only a looser association between the entities. One entity can run on multiple other entities. Examples: Service running on a POD, a CONTAINER or a HOST. |
Smartscape node name: db.instance.name
Smartscape node type: DB_INSTANCE_ORACLE
A Oracle Database instance entity. Represents a physical server on which multiple databases can run.
Fetch all Oracle Database instance entities.
smartscapeNodes DB_INSTANCE_ORACLE
Count instances by their version.
smartscapeNodes DB_INSTANCE_ORACLE| summarize count(), by: { db.instance.version }
The ID is calculated based on the following fields in the defined order: db.connection_details
The following base fields are used for all entities.
| Attribute | Type | Description | Examples |
|---|---|---|---|
| smartscapeId | stableA Smartscape ID consists of two components: an UPPER_CASE entity type and a random 16-character hexadecimal unique identifier, separated by a dash. Use Smartscape conversion functions when working with strings that represent Smartscape IDs. |
|
| string | deprecatedThe entity ID that was used in the classic entity store. This ID is present in old monitoring data. Not all entities have this ID, and it is not generated for new entities. Use the |
|
| string | stableThe entity name. |
|
| string | stableThe entity type. UPPER_SNAKE_CASE string that represents the type of the entity. |
|
| record | stableA consolidated record that aggregates all tag values originating from different contexts. Each nested field within tags represents a specific key (for example, |
|
| timeframe | stableThe lifetime of the entity. This is a record with two nested fields: |
|
| record | stableProvides access to static edges pointing to other entities. In this record each nested field represents a relationship type and target type, and the value is an array of target smartscape IDs. This field is hidden by default but can be added using the fieldsAdd command. |
|
| string[] | resource stableThe security contexts associated with the entity. For Smartscape entities, this field is always an array.Tags: |
|
Fields common to all entities within the databases model.
| Attribute | Type | Description | Examples |
|---|---|---|---|
| ipAddress | experimentalIP address of the listener to which Dynatrace is connected. |
|
| string | experimentalHostname of the listener Dynatrace is connected to. |
|
| string | experimentalPort of the listener Dynatrace is connected to. |
|
| string | experimentalListener connection details in the form |
|
| string | experimentalAn identifier for the database management system (DBMS) product being used. See below for a list of well-known identifiers. |
|
db.system has the following list of well-known values. If one of them applies, then the respective value MUST be used, otherwise a custom value MAY be used.
| Value | Description | Display name |
|---|---|---|
| Adabas (Adaptable Database System) | Adabas |
| Amazon DocumentDB | DocumentDB |
| Amazon Aurora MySQL | Aurora MySQL |
| Amazon Aurora PostgreSQL | Aurora PostgreSQL |
| InterSystems Caché | InterSystems Caché |
| Apache Cassandra | Cassandra |
| ClickHouse | ClickHouse |
| Cloudscape | Cloudscape |
| CockroachDB | CockroachDB |
| ColdFusion IMQ | ColdFusion IMQ |
| Microsoft Azure Cosmos DB | Cosmos DB |
| Couchbase | Couchbase |
| CouchDB | CouchDB |
| Databricks Data Platform | Databricks Data Platform |
| IBM Db2 | IBM Db2 |
| Apache Derby | Derby |
| IBM DL/I | IBM DL/I |
| Amazon DynamoDB | DynamoDB |
| EnterpriseDB | EnterpriseDB |
| Elasticsearch | Elasticsearch |
| FileMaker | FileMaker |
| Firebird | Firebird |
| FirstSQL | FirstSQL |
| Apache Geode | Geode |
| H2 | H2 |
| SAP HANA | SAP HANA |
| Apache HBase | HBase |
| Apache Hive | Hive |
| HyperSQL DataBase | HSQLDB |
| Informix | Informix |
| Ingres | Ingres |
| InstantDB | InstantDB |
| InterBase | InterBase |
| Amazon Keyspaces for Apache Cassandra | Keyspaces |
| MariaDB | MariaDB |
| SAP MaxDB | SAP MaxDB |
| Memcached | Memcached |
| MongoDB | MongoDB |
| Microsoft SQL Server | SQL Server |
| Microsoft SQL Server Compact | SQL Server Compact |
| MySQL | MySQL |
| Neo4j | Neo4j |
| Amazon Neptune | Neptune |
| Netezza | Netezza |
| OpenSearch | OpenSearch |
| Oracle Database | Oracle |
| Some other SQL database. Fallback only. See notes. | Other SQL |
| Pervasive PSQL | Pervasive PSQL |
| Apache Phoenix | Apache Phoenix |
| PointBase | PointBase |
| PostgreSQL | PostgreSQL |
| Progress Database | Progress |
| Redis | Redis |
| Amazon Redshift | Redshift |
| Snowflake Data Platform | Snowflake Data Platform |
| Cloud Spanner | Cloud Spanner |
| SQLite | SQLite |
| Sybase | Sybase |
| Teradata | Teradata |
| Valkey | Valkey |
| Vertica | Vertica |
Fields that are common across all DB_INSTANCE_* type nodes.
| Attribute | Type | Description | Examples |
|---|---|---|---|
| string | experimentalName of the database instance. |
|
| string | experimentalVersion of the database instance as reported by the database vendor. |
|
Specific attributes for all Oracle Database entities.
| Attribute | Type | Description | Examples |
|---|---|---|---|
| string | experimentalDatabase open mode. |
|
Specific attributes of Oracle Database instance entity.
| Attribute | Type | Description | Examples |
|---|---|---|---|
| string | experimentalIndicates whether the instance is mounted in cluster database mode. |
|
| string | experimentalIndicates whether the instance is in unrestricted mode, allowing logins by all users, or in restricted mode, allowing logins by database administrators only. |
|
| string | experimentalInstance mode of the current instance. |
|
| string | experimentalQuiesce state of the instance. |
|
| string | experimentalStatus of the instance. |
|
| string | experimentalIndicates whether the instance is an active instance or an inactive secondary instance. |
|
Specific attributes of Oracle Database cluster entity.
| Attribute | Type | Description | Examples |
|---|---|---|---|
| string | experimentalArchive log mode. |
|
| string | experimentalCurrent role of the database. |
|
| string | experimentalIndicates whether flashback is ON. |
|
| string | experimentalIndicates whether Oracle Dataguard is enabled. |
|
| Type | Target type | Kind | Description |
|---|---|---|---|
|
| static | stableDefines if the instance is part of a cluster, similar to a composition in UML. The source (child) cannot exist without the destination (parent). |
|
| static | stableDefines a "vertical" relation of an entity running on some other entity. It does not imply any composition or aggregation but only a looser association between the entities. One entity can run on multiple other entities. Examples: Service running on a POD, a CONTAINER or a HOST. |
|
| static | experimentalDefines an equivalence relationship. Examples: A database instance is the same as a host process. |