oraDbTablespaceState
ORADB-MIB ·
.1.3.6.1.4.1.111.4.1.2.1.5
Object
column
mandatory
Enumeration
The current accessibility of this tablespace. If a tablespace is offline(2), then SQL statements cannot reference objects contained in the tablespace. An invalid(3) tablespace is one that has been dropped.
Context
- MIB
- ORADB-MIB
- OID
.1.3.6.1.4.1.111.4.1.2.1.5- Type
- column
- Access
- readonly
- Status
- mandatory
- Parent
- oraDbTablespaceEntry
- Table
- oraDbTablespaceTable
- Siblings
- 5
Syntax
Enumeration
Values & Constraints
Enumerated Values
1 | online |
2 | offline |
3 | invalid |
Related Objects
Sibling Objects
| Object | Type | Syntax | OID |
|---|---|---|---|
| oraDbTablespaceIndex mandatory A numeric index, unique among tablespaces within a single
Oracle database. | column | Integer32 | .1.3.6.1.4.1.111.4.1.2.1.1 |
| oraDbTablespaceName mandatory The name of this tablespace. | column | RFC1213-MIBDisplayString | .1.3.6.1.4.1.111.4.1.2.1.2 |
| oraDbTablespaceSizeAllocated mandatory The amount of disk space, in kilobytes, allocated for this
tablespace. This is the sum of the sizes of the data files
associated with the tablespace. | column | Integer32 | .1.3.6.1.4.1.111.4.1.2.1.3 |
| oraDbTablespaceSizeUsed mandatory The amount of disk space, in kilobytes, which is actually in
use for storing data. | column | Integer32 | .1.3.6.1.4.1.111.4.1.2.1.4 |
| oraDbTablespaceLargestAvailableChunk mandatory The size, in kilobytes, of the largest contiguous set of free
data blocks in the tablespace. | column | Integer32 | .1.3.6.1.4.1.111.4.1.2.1.6 |