Oracle User Tablespaces Test
This test measures the number of users currently using the system tablespace. 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 |
---|---|---|---|
System tablespace users: |
Indicates the number of users (other than sys/system users) who are currently using the system tablespace as their default or temporary tablespace |
Number |
It is not desirable for application users to be using system tablespace as their default or temporary tablespace. If you want the eG Enterprise suite to ignore a few users while measuring the number of current users, then set the Maximum Threshold accordingly. By default, the Maximum Threshold is set to “none”. For eg., OUTLN and DBSNMP are two default users of the system tablespace. Therefore, the value of this measure will also be 2, by default. Moreover, since the Maximum Threshold of this measure, is by default “none”, any value greater than 0, will trigger an alarm. Since the value 2 is greater than 0, an alarm will be generated for this measure. To avoid such an alarm-generation, change the Maximum Threshold to 2. When this is done, the eG Enterprise system will ignore the 2 default users and will generate an alarm only when additional users begin using the system tablespace. |
The detailed diagnosis of the System tablespace users measure, if enabled, lists the users who are currently using the system tablespace (see Figure 1). When there is a steep increase in the number of system tablespace users, then, this information will help in identifying the specific users using the tablespace. Such users, if found unwanted, can be dropped. Alternatively, the default or temporary tablespace of such users can be changed.
Figure 1 : The detailed diagnosis of the System tablespace users measure