Skip to toolbar

Oracle DBA 10g OCP

|Oracle 10g OCP|

Training at Nhames Limited is a wonderful experience.

ORACLE 10g OCP Certification Exam and Courses Highlight:

Database Administrator: Database Administrators are responsible for administrative activities like installing database, taking backups, managing and fine-tuning performance over the network, and data recovery. They have the knowledge of basic architecture of the Oracle database.

OCP Exam #1Z0-043

Oracle Database 10g: Administration II
Using Globalization Support Objectives
Customize language-dependent behavior for the database and individual sessions
Specify different linguistic sorts for queries
Use datatime datatypes
Query data using case insensitive and accent insensitive searches
Obtain Globalization support configuration information

Securing the Oracle Listener
Secure the listener
Remove default EXTPROC entry and add a separate listener to handle external procedure calls

Configuring Recovery Manager
Configure database parameters that affect RMAN operations
Change RMAN default settings with CONFIGURE
Manage RMAN’s persistent settings
Start RMAN utility and allocate channels

Recovering from User Errors
Recover a dropped table using Flashback technology
Perform Flashback table operation
Manage the recycle bin
Recover from user errors using Flashback versions query
Perform transaction level recovery using Flashback Transaction query

Dealing with Database Corruption
Define block corruption and list its causes and symptoms
Detect database corruptions using the following utilities: ANALYZE
DBVERIFY
Detect database corruptions using the dbms_repair package
Implement the DB_BLOCK_CHECKING parameter to detect corruptions
Repair corruptions using RMAN

Automatic Database Management
Use the Database Advisors to gather information about your database
Use the SQL Tuning Advisor to improve database performance
Use automatic undo retention tuning

Using Recovery Manager
Use the RMAN BACKUP command to create backup sets and image copies
Enable block change tracking
Manage the backups and image copies taken with RMAN with the LIST and REPORT commands

Diagnostic Sources
Use the alert log and database trace files for diagnostic purposes
View alerts using Enterprise Manager
Adjust thresholds for tracked metrics
Control the size and location of trace files

Monitoring and Managing Storage
Tune redo writing and archiving operations
Issue statements that can be suspended upon encountering space condition errors
Reduce space-related error conditions by proactively managing tablespace usage
Reclaim wasted space from tables and indexes using the segment shrink functionality
Estimate the size of new table and indexes
Use different storage options to improve the performance of queries
Rebuild indexes online

Automatic Storage Management
Set up initialization parameter files for ASM and database instances
Execute SQL commands with ASM file names
Start up and shut down ASM instances
Administer ASM disk groups
Use RMAN to migrate your database to ASM

Recovering from Non-Critical Losses
Recover temporary tablespaces
Recover a redo log group member
Recover index tablespaces
Recover read-only tablespaces
Recreate the password file

Monitoring and Managing Memory
Implement Automatic Shared Memory Management
Manually configure SGA parameters for various memory components in the SGA
Use Automatic PGA Memory Management

Database Recovery
Recover the control file
Explain reasons for incomplete recovery
Perform incomplete recovery using EM
Perform incomplete recovery using RMAN
Perform incomplete recovery using SQL
Perform database recovery following a RESETLOGS operation

Flashback Database
Determine which flashback technology to use for each recovery situation
Configure and sue Flashback Database
Monitor the Flashback Database
Use the Enterprise Manager Recovery Wizard to flashback database
Manage (or maintain) the Flash Recovery Area

Why Train with us :

Menu

@

Not recently active
Send this to a friend