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.