Oracle SNMP Support Reference Guide
The oraDbSGATable contains storage allocation information on the current System Global Area (SGA). The SGA is a common database storage area for information that supports current sessions. As the values of its attributes are configured in the INIT.ORA file, they do not change while the database instance is running, thus, the SGA at this aggregate level is not as important to monitor as other database structures.
Each entry in the oraDbSGATable represents the SGA for a current database instance on the node. Each entry is indexed by rdbmsDbIndex. However, because rdbmsDbTable contains an entry for each installed database configured for SNMP support, whether or not it is actively open, there may or may not be a one-to-one correspondence between entries in the two tables at any point in time. (For details about rdbmsDbIndex, see Appendix E, "Interpreting Variables of the Public RDBMS MIB.") The current value of each oraDbSGATable variable is retrieved directly from a corresponding field in the V$SGA table for that database instance.
Table A - 6 lists each variable of the oraDbSGATable and its corresponding object ID.
| Variable Name
| Object ID
|
| oraDbSGAFixedSize
| 1.3.6.1.4.1.111.4.1.6.1.1
|
| oraDbSGAVariableSize
| 1.3.6.1.4.1.111.4.1.6.1.2
|
| oraDbSGADatabaseBuffers
| 1.3.6.1.4.1.111.4.1.6.1.3
|
| oraDbSGARedoBuffers
| 1.3.6.1.4.1.111.4.1.6.1.4
|
Table A - 6. oraDbSGATable Variables and Corresponding Object IDs
| Syntax | INTEGER (1..2147483647) |
| Max-Access | read-only |
| Explanation | The size in kilobytes of the fixed-size portion of the SGA as shown in V$SGASTAT. |
| Typical Range | 1 - 2147483647
|
| Significance | less important |
| Related Variables | oraDbSGAVariableSize
|
| Suggested Presentation | as a simple integer value
|
| Syntax | INTEGER (1..2147483647) |
| Max-Access | read-only |
| Explanation | The size in kilobytes of the variable-size portion of the SGA as shown in V$SGASTAT. |
| Typical Range | 1 - 2147483647
|
| Significance | less important |
| Related Variables | oraDbSGAFixedSize
|
| Suggested Presentation | as a simple integer value
|
| Syntax | INTEGER (1..2147483647) |
| Max-Access | read-only |
| Explanation | The number of database buffers allocated in the SGA as shown in V$SGASTAT. |
| Typical Range | 4 Kbytes - 2 Gbytes
|
| Significance | less important |
| Related Variables | oraDbSGARedoBuffers
|
| Suggested Presentation | as a simple integer value
|
| Syntax | INTEGER (1..2147483647) |
| Max-Access | read-write |
| Explanation | The number of redo buffers allocated in the SGA as shown in V$SGASTAT. |
| Typical Range | 1 - 2147483647
|
| Significance | less important |
| Related Variables | oraDbSGADatabaseBuffers
|
| Suggested Presentation | as a simple integer value
|