OracleDatabaseInstance
Information about Oracle database instances.
erDiagram
Machine ||--o{ OracleDatabaseInstance : "MachineID"
OracleDatabaseInstance ||--o{ OracleDatabaseInstanceDatabase : "OracleDatabaseInstanceID"
OracleDatabaseInstance ||--o{ OracleDatabaseInstanceParameter : "OracleDatabaseInstanceID"
Fields
| Field |
Type |
Description |
| Banner |
string |
Banner information of the Oracle database instance |
| CloudManagementPack |
boolean |
Indicates if the Cloud Management Pack is enabled |
| Created |
datetime |
Date/Time this record was created |
| DatabaseCreated |
datetime |
Date/Time the database was created |
| DatabaseName |
string |
Name of the Oracle database instance |
| DatabaseRole |
string |
Role of the Oracle database instance |
| DataLifecyclePack |
boolean |
Indicates if the Data Lifecycle Pack is enabled |
| DataMaskingPack |
boolean |
Indicates if the Data Masking Pack is enabled |
| DbId |
numeric |
Database ID |
| DdlLogging |
boolean |
Indicates if DDL logging is enabled |
| DiagnosticsPack |
boolean |
Indicates if the Diagnostics Pack is enabled |
| DocumentGuid |
guid |
GUID of the document |
| ExtraData |
string |
Additional data related to the Oracle database instance in JSON format |
| HostName |
string |
Host name of the Oracle database instance |
| ID |
numeric |
Internal ID for the OracleDatabaseInstance entity (Primary Key) |
| InstanceName |
string |
Name of the Oracle database instance |
| LastSampleDate |
datetime |
Date/Time of the last sample |
| LastScan |
datetime |
Date/Time of the last scan |
| LastSysDate |
datetime |
Date/Time of the last system date |
| MachineID |
numeric |
Internal ID that references the Machine entity (Foreign Key) |
| Notes |
string |
Notes related to the Oracle database instance |
| OpenMode |
string |
Instance open mode at time of last scan |
| Res1 |
string |
Reserved for future use |
| Res2 |
string |
Reserved for future use |
| TuningPack |
boolean |
Indicates if the Tuning Pack is enabled |
| Version |
string |
Version of the Oracle database instance |
References
| Column Name |
Referenced Table |
Description |
| MachineID |
Machine |
Basic machine information. A machine is a physical or virtual device that can be scanned by OctoSAM Inventory. A machine can also be a mobile device such as a phone or tablet. |
Referenced by