This test requires a thorough knowledge of administrative tasks for managing the database for optimal performance. The candidate appearing in this test should have a sound knowledge of various tools available in Oracle9i for managing different issues in the database. This includes identifying contentions and resolving them through the tools. For this purpose, one should practice the following to a good extent:
- Identifying tuning areas through querying the available views.
- Gathering statistics through available tools, such as STATSPACK.
- Using the available GUI tools, such as Instance Manager to resolve contentions.
- Changing the values of various initialization parameters to monitor the subsequent affect on the system performance.
- Changing the size of various database objects, such as buffers, pools, tablespace, and rollback segments to monitor its affect on the performance of the system.
- Performing administrative tasks, such as setting frequency of checkpoints to monitor the affect on the system performance.
- Identifying and resolving locking contentions by using the available views and GUI tools.
- Configuring various processes in the shared server architecture, such as, Oracle Net listener and the dispatcher.
- Configuring block parameters, such as PCTFREE and PCTUSED for enhanced performance.
- Configuring materialized views through the initialization parameters for optimal performance.
- Employing different types of indexes for storage purposes and monitoring the performance in each case through the available views.