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.
Pass OCP DBA 9i certification exam in first attempt. Download latest exam simulation, questions, tutorial and study guide for OCP DBA 9i:
What is Oracle 11g DBA OCA, Oracle9i DBA OCA, and Oracle PL/SQL Developer Certified Associate?
Oracle 11g DBA OCA, Oracle9i DBA OCA, and Oracle PL/SQL Developer Certified Associate are some of the certification levels offered by Oracle. It prepares a candidate to build intensive internet applications for Oracle database. You should be very well versed with how to write a PL/SQL programs to qualify the certification test. It also prepares you for the next certification level to become an Oracle Form Developer. It is an essential certification for the advanced certification level (OCP DBA 9i).
What is OCA DBA (10g) certification?
OCA DBA (10g) certification is the most fundamental and entrance level certification on DBA track on 10g platform. Its objectives are intended to measure a candidate’s ability to work as a junior team member with Database Administrators or Application Developers. This certification is the first step towards the more advanced OCP – 10g certification. The certification requires the comprehensive skills in the following areas:
Robert G. Freeman is a Principal Engineer and Database Team Manager at the Church of Jesus Christ of Latter-Day Saints in Salt Lake City, UT, USA. He has been working with Oracle Databases for almost two decades. Robert is the author of several books including Oracle Database 10g RMAN Backup and Recovery and Oracle Database 11g New Features. Robert is an Oracle ACE, and is currently the only residing ACE in the state of Utah, USA. When not working with Oracle databases Robert may be found flying around in his airplane, kicking in karate class or just hanging out with his wife, kids, 2 cats and a dog named Denali.
Robert is a co-author for following uCertify PrepKit:
1Z0-051: OCA: Oracle Database 11g-SQL Fundamentals-I
Deepak Jaisingh has 10+ years of technical experience in various industries like Banking, Manufacturing, Insurance etc. His expertise lie in Database and System Administration. His “Never Give Up” attitude is the reason behind all his success. He started his career in a small call center, then very soon he migrated to IT and from there on he never looked back. Oracle became his passion and his job, his obsession.
Deepak is an Oracle certified professional (OCP) and Sun Certified Java Professional (SCJP). He is currently perusing OCM.
Deepak is co-author and contributor for following PrepKits:
1Z0-042: Oracle 10g DBA Admin I
1Z0-043: Oracle 10g DBA Admin I,
1Z0-047: Oracle 11g SQL Expert