Oracle Objects Test
The OracleObjects test is used to monitor one or more database user accounts. This test is disabled by default. To enable the test, go to the enable / disable tests page using the menu sequence : Agents -> Tests -> Enable/Disable, pick Oracle Database as the Component type, Performance as the Test type, choose this test from the disabled tests list, and click on the << button to move the test to the ENABLED TESTS list. Finally, click the Update button.
Target of the test : An Oracle server
Agent deploying the test : An internal agent
Outputs of the test : One set of results for every user account monitored.
|
Measurement | Description | Measurement Unit | Interpretation |
---|---|---|---|
Invalid objects: |
The number of invalid objects in the database for a specific user account. The detailed diagnosis capability, if turned on, provides the list of invalid objects and their type. |
Number |
The detailed diagnosis capability for this measure, if enabled, lists the names and the type of the invalid objects of a user. |
Modified objects: |
The number of objects for a specific user account that have been modified in the last measurement period |
Number |
This measure allows changes to the database structure to be tracked over time. The detailed diagnosis capability, if enabled, indicates the names of the objects that have been modified and their type. |
The detailed diagnosis of the Invalid objects measure lists the invalid objects in the database for a user (see Figure 1). By dropping such invalid objects, tablespace can be conserved.
Figure 1 : The detailed diagnosis of the Invalid objects measure