|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 :