Oracle Parameters Test
This test tracks changes made to the default values of parameters. 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 instance of an Oracle database.
|
Measurement | Description | Measurement Unit | Interpretation |
---|---|---|---|
Non-default parameters: |
Indicates the number of parameters for which the default value has changed. |
Number |
Changes in this value enables users to track changes made to the database settings. In case you want to ignore a few parameters, change the thresholding policy for this measure, to the above effect. |
The detailed diagnosis capability of the Non-default parameters measure, if enabled, lists the parameters that have not retained their default values (see Figure 1). This information helps an administrator in tracking the changes made to the parameters.
Figure 1 : The detailed diagnosis of the Non-default parameters measure