Oracle Large Table Test
Larger tables in an Oracle database server may be prone to fragmentation which may reduce the performance of the database as well as result in longer query times when a full scan is performed. To improve the overall performance of the database server and optimize the query times, it is essential to check whether the tables are indexed appropriately and if partitioning of the tables are necessary. This check when performed on the larger tables, will automatically improve the query response time thus providing a better overall performance. Prior to performing this check, the administrators should identify the tables that are large and are more resource intensive on their database. The Oracle Large Table test helps the administrators to determine such large tables.
This test tracks the tables in an Oracle database server and reports the number of tables that are larger than the configured limit.
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 |
---|---|---|---|
Large Tables: |
Indicates the number of tables in the database server that exceed the limit configured against the TABLE SIZE GB parameter |
Number |
The detailed diagnosis for this measure reveals the details of the tables that are large in size. |