oraDbDataFileEntry
ORADB-MIB ·
.1.3.6.1.4.1.111.4.1.3.1
Object
row
mandatory
Information for each data file within an Oracle database.
Context
- MIB
- ORADB-MIB
- OID
.1.3.6.1.4.1.111.4.1.3.1- Type
- row
- Status
- mandatory
- Parent
- oraDbDataFileTable
- Table
- oraDbDataFileTable
- Children
- 9
Syntax
No syntax metadata recorded.
Values & Constraints
No enumerated values or constraints recorded.
Related Objects
Child Objects
| Object | Type | Syntax | OID |
|---|---|---|---|
| oraDbDataFileIndex mandatory A numeric index, unique among data files associated with a
single tablespace. | column | Integer32 | .1.3.6.1.4.1.111.4.1.3.1.1 |
| oraDbDataFileName mandatory The fully-qualified name of this datafile. | column | RFC1213-MIBDisplayString | .1.3.6.1.4.1.111.4.1.3.1.2 |
| oraDbDataFileSizeAllocated mandatory The allocated size, in kilobytes, of this data file. | column | Integer32 | .1.3.6.1.4.1.111.4.1.3.1.3 |
| oraDbDataFileDiskReads mandatory The total number of reads issued against this data file since
startup. | column | RFC1155-SMICounter | .1.3.6.1.4.1.111.4.1.3.1.4 |
| oraDbDataFileDiskWrites mandatory The total number of writes issued against this data file since
startup. | column | RFC1155-SMICounter | .1.3.6.1.4.1.111.4.1.3.1.5 |
| oraDbDataFileDiskReadBlocks mandatory The total number of physical blocks read from this data file
since startup. | column | RFC1155-SMICounter | .1.3.6.1.4.1.111.4.1.3.1.6 |
| oraDbDataFileDiskWrittenBlocks mandatory The total number of physical blocks written to this data file
since startup. | column | RFC1155-SMICounter | .1.3.6.1.4.1.111.4.1.3.1.7 |
| oraDbDataFileDiskReadTimeTicks mandatory The time spent reading from this data file since startup IF
the database parameter TIMED_STATISTICS is TRUE. If
TIMED_STATISTICS is FALSE, then the value will be zero. | column | RFC1155-SMICounter | .1.3.6.1.4.1.111.4.1.3.1.8 |
| oraDbDataFileDiskWriteTimeTicks mandatory The time spent writing to this data file since startup IF
the database parameter TIMED_STATISTICS is TRUE. If
TIMED_STATISTICS is FALSE, then the value will be zero. | column | RFC1155-SMICounter | .1.3.6.1.4.1.111.4.1.3.1.9 |
Indexes
| Object | Type | Syntax | OID |
|---|---|---|---|
| RDBMS-MIBrdbmsDbIndex A numeric index, unique among all the databases from all
products on this host. This value is a surrogate for the
conceptually unique key, which is {PrivateMibOID,
databasename} | column | Integer32 | .1.3.6.1.2.1.39.1.1.1.1 |
| oraDbDataFileIndex mandatory A numeric index, unique among data files associated with a
single tablespace. | column | Integer32 | .1.3.6.1.4.1.111.4.1.3.1.1 |