oraDbTablespaceEntry

ORADB-MIB · .1.3.6.1.4.1.111.4.1.2.1

MIB view Table view

Object

row mandatory

Information for each tablespace within an Oracle database.

Context

MIB: ORADB-MIB
OID: .1.3.6.1.4.1.111.4.1.2.1
Type: row
Status: mandatory
Parent: oraDbTablespaceTable
Table: oraDbTablespaceTable
Children: 6

Syntax

No syntax metadata recorded.

Values & Constraints

No enumerated values or constraints recorded.

Related Objects

Child 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`
oraDbTablespaceState mandatory 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 i…	column	Enumeration	`.1.3.6.1.4.1.111.4.1.2.1.5`
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`

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`
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`