OracleInstance Table

OracleInstance stores key characteristics specific to instances of Oracle databases which may impact the cost of licensing.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for OracleInstance table

Database Column



Type: integer. Key

The database instance whose attributes are being stored. Foreign key to the Instance table.


Type: integer

The environment of the database instance. Foreign key to the InstanceEnvironment table.


Type: integer

The role of the database instance. Foreign key to the InstanceRole table.