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:

  1. Identifying tuning areas through querying the available views.
  2. Gathering statistics through available tools, such as STATSPACK.
  3. Using the available GUI tools, such as Instance Manager to resolve contentions.
  4. Changing the values of various initialization parameters to monitor the subsequent affect on the system performance.
  5. 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.
  6. Pass OCP DBA 9i certification exam in first attempt. Download latest exam simulation, questions, tutorial and study guide for OCP DBA 9i:

Comments are closed.