Oracle10g DBA OCA-OCP Exam Preparation

Day 1: Oracle DBA Concepts
Oracle10g Instance creation and management
What is an Oracle Instance?
Installing Oracle
Oracle Optimal Flexible Architecture (OFA)
Locating initialization, listener.ora & sqlnet.ora files
Finding the alert log
Common environment variables
Structures in an Oracle Instance
Oracle Memory Structures, SGA and PGA
Oracle Processes and their purposes
Startup nomount, mount and open database commands
Sample Oracle10g OCP exam questions
Oracle10g Database Architecture
Oraclde10g management framework
Using the Database Creation Assistant (DBA)
Creating and dropping a database
Tablespaces
Tables and Indexes
Clusters
Partitioning of Tables and Indexes
Gathering and applying patches
Sample Oracle10g OCP exam questions
Day 2:
Concurrency Management
Transactions, serialization, locks and latches
Lock modes
Detecting and resolving lock conflicts
Managing deadlocks
Interfacing with Oracle
Oracle transaction management
Using SQL*Plus and iSQL*Plus
Using embedded Oracle with Pro*C & Java
PL/SQL & Triggers
Pining PL/SQL packages & compiling PL/SQL
System-level triggers – startup trigger, logon trigger, PL/SQL error trigger
Oracle*Net
Basic Network structure
Oracle*Net Files
Multi-threaded server
Create additional listeners
Create Oracle Net service aliases
Configure connect time failover
Use ping and tnsping
Oracle*Net names resolution
Sample Oracle10g OCP exam questions
Day 3: DBA Management
Tablespace Management Overview
Dictionary Managed Tablespaces
Locally Managed Tablespaces
Automatic Segment Space Management
Moving tablespaces online and offline
Sample Oracle10g OCP exam questions
UNDO Tablespace Management
Use of undo segments
Creating an undo tablespace
User managed undo tablespaces
Automatic undo management
Monitor & Configure undo retention
Use the Undo Advisor
Size the undo tablespace
Sample Oracle10g OCP exam questions
Oracle Utilities
Datapump – Import/export
SQL*Loader
Oracle streams
Day 4: Oracle Performance Tuning
Oracle Performance Tuning
Locate invalid and unusable objects
Gather SQL optimizer statistics with dbms_stats
Basic Oracle performance metrics
Use OEM and dbms_alert to set warning and critical alert thresholds
The SQL Tuning Advisor
The SQL Access Advisor
Interpreting server generated alerts
Oracle advisory utilities v$db_cache_advice, v$shared_pool_advice, v$pga_aggregate_target_advice
Using OEM performance screens
Fixing performance issues
Day 5: Oracle security and user management
User Management
Creating Users
Altering users
User Profiles
User resource groups
Granting privileges & roles
Auditing user activity with dbms_audit
Sample Oracle10g OCP exam questions
Oracle Security
Password use in Oracle
Password encryption and password aging
External authentication
Using Single sign-on (SSO)
Object security
Virtual Private Databases (VPD) in Oracle
Oracle “grant execute” security
Use of Roles in Oracle
Register for security updates
Sample Oracle10g OCP exam questions
Backup & Recovery
Oracle backup & recovery planning
Parallel instance recovery
Basics of checkpoints, redo log files, and archived log files
Using ARCHIVELOG mode
Creating consistent Oracle backups
Online hot backups
Incremental Oracle backups
Automating database backups with dbms_scheduler
Monitor the flash recovery area
Recovering from loss of a Control file
Recovering from loss of a Redo log file
Recovering from loss of a system-critical data file
Recovering from loss of a non system-critical data file
OCP Final Exam Review
Full sample OCP DBA exam
OCP testing techniques for success

Testing tips and secrets


Gửi phản hồi

Please log in using one of these methods to post your comment:

WordPress.com Logo

Bạn đang bình luận bằng tài khoản WordPress.com Log Out / Thay đổi )

Twitter picture

Bạn đang bình luận bằng tài khoản Twitter Log Out / Thay đổi )

Facebook photo

Bạn đang bình luận bằng tài khoản Facebook Log Out / Thay đổi )

Google+ photo

Bạn đang bình luận bằng tài khoản Google+ Log Out / Thay đổi )

Connecting to %s