Oracle SNMP Support Reference Guide

Contents Glossary Index Home Previous Next

oraDbTablespaceTable

The oraDbTablespaceTable contains information on tablespaces within a current Oracle database instance. A tablespace is a logical portion of an Oracle database used to allocate storage for table and index data. In a production environment, tables can fill up as transaction activity mounts. Monitoring tablespace activity is important to avoid exhausting the tablespaces and causing spaces.

Each entry in the oraDbTablespaceTable represents a given tablespace within a current database instance. Each entry is indexed first by rdbmsDbIndex, and then oraDbTablespaceIndex; thus, there will normally be a one-to-many relationship between an rdbmsDbTable entry and corresponding oraDbTablespaceTable entries. (For details about rdbmsDbIndex, see Appendix E, "Interpreting Variables of the Public RDBMS MIB.") The current value of each oraDbTablespaceTable variable is retrieved directly from a join of DBA_TABLESPACES, DBA_DATA_FILES, and DBA_FREE_SPACE selecting for the tablespace in question.

Table A - 2 lists each of these variables and its corresponding object ID.

Variable Name Object ID
oraDbTablespaceIndex 1.3.6.1.4.1.111.4.1.2.1.1
oraDbTablespaceName 1.3.6.1.4.1.111.4.1.2.1.2
oraDbTablespaceSizeAllocated 1.3.6.1.4.1.111.4.1.2.1.3
oraDbTablespaceSizeUsed 1.3.6.1.4.1.111.4.1.2.1.4
oraDbTablespaceState 1.3.6.1.4.1.111.4.1.2.1.5
oraDbTablespaceLargestAvailableChunk 1.3.6.1.4.1.111.4.1.2.1.6
Table A - 2. oraDbTablespaceTable Variables and Corresponding Object IDs

oraDbTablespaceIndex

Syntax INTEGER (1..2147483647)
Max-Access not-accessible
Explanation A numeric index, unique among tablespaces within a single Oracle database instance. This index is assigned to these tablespaces based on the alphabetical order of their names. On most platforms, a hard file limit of 1023 database files exists, so this number is the practical upper limit. Although some administrators prefer a one-to-one relationship between tablespaces and database files, multiple files can comprise a tablespace.
Typical Range 1 - 1,000
Significance very important
Related Variables oraDbTablespaceName, rdbmsDbIndex
Suggested Presentation not applicable

oraDbTablespaceName

Syntax DisplayString
Max-Access read-only
Explanation Indicates the name of this tablespace, as retrieved from the value for NAME in V$TABLESPACE.
Typical Range 0 - 30 characters
Significance important
Related Variables oraDbTablespaceIndex
Suggested Presentation simple string

oraDbTablespaceSizeAllocated

Syntax Integer32
Max-Access read-only
Explanation Indicates 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.
Typical Range 0 - 10 gigabytes
Significance important
Related Variables oraDbTablespaceSizeUsed
Suggested Presentation simple string

oraDbTablespaceSizeUsed

Syntax Integer32
Max-Access read-only
Explanation Indicates the amount of disk space (in kilobytes) which is actually in use for storing data. This is the difference between the sum of the size of the datafiles associated with the tablespace and the sum of the size of the free spaces associated with the tablespace.
Typical Range 0 - value of oraDbTablespaceSizeAllocated
Significance Very important
Related Variables oraDbTablespaceSizeAllocated
Suggested Presentation gauge

oraDbTablespaceState

Syntax INTEGER (1) online (2) offline, or (3) invalid
Max-Access read-only
Explanation Indicates the current accessibility of this tablespace, as retrieved from the value for STATUS in V$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.
Typical Range enumerated 1 - 3
Significance very important
Related Variables none
Suggested Presentation simple string or icon

oraDbTablespaceLargestAvailableChunk

Syntax Integer32
Max-Access read-only
Explanation Indicates the size (in kilobytes) of the largest contiguous set of free data blocks in the tablespace. This variable is retrieved directly from the value for NEXT_EXTENT in DBA_TABLES. If there is any object in the tablespace whose NEXT_EXTENT value is greater than the layout chunk, that object will be unable to expand. This might cause a major problem, or on the other hand, it might not matter in the slightest.
Typical Range Less than or equal to (oraDbTablespaceSizeAllocated minus oraDbTablespaceSizeUsed)
Significance important
Related Variables oraDbTablespaceSizeAllocated, oraDbTablespaceSizeUsed
Suggested Presentation gauge

Contents Glossary Index Home Previous Next