What is Tested in Oracle 10g Certification Exam
If you were certificated by Oracle in 9i, you only need to pass one upgrade new feature exam to get Oracle 10g DBA certification. The exam is easy because it only tests the basic knowledge of Oracle 10g. Also, a lot of knowledge of the new feature are not really new, you already learned a lot of them from the previous version. Anyway, the following list shows the terminologies and concepts that got to be tested in the new feature exam. Make yourself familiar with them. Check the Oracle documentation or search online if you are not clear. Then you are ready to pass. Good luck!
ASM Rebalance (ARBn) - background process to perform the rebalance data extent movements across ASM disk.
Automated SQL Execution Memory Management - Enabled by setting WORKAREA_SIZE_POLICY to AUTO and specifying PGA_AGGREGATE_TARGET
Automatic Consumer Group Switching
Automatic Database Diagnostic Monitor (ADDM) - Run by DBMS_ADVISOR, Enterprise Manager, or addmrpt.sql script, run every 60 minutes by default.
Automatic Segment Advisor - identify the segments that you should shrink.
Automatic Segment-Space Management (ASSM)
Automatic Shared Memory Management (ASMM) - use Memory Manager (MMAN) background process.
Automatic Storage Management (ASM)
Automatic Tuning Optimizer (ATO) - provide recommendations to create indexes, create SQL profile, gather relevant statistics, restructure SQL statements.
Automatic Workload Repository (AWR) - set AWR snapshot time interval to let ADDM run a period of time, AWR snapshot generated every 60 minutes by default.
Bigfile Tablespace (BFT) - can be resized or ATUOEXTEND ON, has only 1 data file.
Block change track file - Records block change info, minimum size 10MB with 10MB increments, fully automatic maintenance, change tracked when redo generated, turned off by default.
block change tracking - for faster increment backups, the tracking file written by CTWR
Block Media Recovery - faster recovery, increased data availability during recovery, use Recovery Manager
Change Tracking Writer (CTWR) - background process to write block change tracking files.
Character Large Object (CLOB) - as the AL16UTF16 character set in Oracle database.
Character Set Scanner (CSSCAN) - selective scanning and support for new data types
Data Guard architecture
Data Guard Broker
Data Pump jobs - manages dump files, log files, and SQL files. Listed in DBA_DATAPUMP_JOBS
Data Resource Manager
Database Configuration Assistant (DBCA) - automate database backups and gathering optimizer statistics.
Endian Format of Platform - can be viewed in V$DATABASE and V$TRANSPORTABLE_PLATFORM
File Level Recovery
Flash Recovery Area - maintains recovery-related files: data file, control file, control file autobackups, archived log file, flashback logs, RMAN file
Flashback Database - Must set Flash Recovery Area, enable Flashback logging, and run on ARCHIVELOG mode. Check V$DATABASE to see if it is enabled.
Flashback Versions Query - Use VERSIONS clause for heap table and index-organized tables
Index-Organized Tables (IOT)
Language and Character Set Scanner (LCSSCAN) - support HTML files.
Log Transport Services - to control the automated transfer or redo data from the production database to one or more archival destinations.
Memory Manager (MMAN) - background process serves as SGA Memory Broker to coordinate the sizing of memory components.
Online table redefinition - Modify storage parm, add or remove parallel support, change table organization (help organized, index-organized, etc)
Oracle Data Pump - Data Pump jobs use a master table, a master process, and worker processes to perform the work and keep track of progress.
Oracle Flashback Table - recover table to a specified point quickly without taking database offline.
Oracle Managed Files database (OMF)
Oracle Management Agent (OMA)
Policy Framework - in Enterprise Manager to evaluate policies automatically.
Recovery Manager (RMAN)
Resumable space allocation feature - Space requirement beyond user quota will wait in suspended state until quota increased or timeout. Resumable mode is turned on by ALTER SESSION ENABLE RESUMABLE or setting RESUMABLE_TIMEOUT parm to nonzero value.
RMAN persistent configuration feature - Set retention period, store settings for channel attributes.
Segment Advisor (SA)
Server generated alert - alert for tablespace space usage, resumable session suspended, recovery area space usage
Server parameter file (SPFILE)
Shared Across Multiple Objects
Shared policy function - static and context-sensitive policies, can be enforced on any number of objects.
Shared server-side parameter file - can contain parameters with distinct values for each instance
SQL Access Advisor (SAA) - help performance tuning by recommending indexes, materialized views, and logs.
SQL Tuning Advisor (STA) - used to tune SQL workload.
Standby Redo Logs - used on the primary database to allow the primary and a standby database to switch roles easily.
Unified Job Scheduler - Its occupant cannot be relocated.
Version -Enabled Table - must have primary key, non-supported triggers are deactivated, version-enabled child table must has version-enabled parent.
Virtual Database Policy (VDP)
Virtual Private Database policy (VPD) - by default apply to select, insert, update, and delete statements.