Oracle OCP Certification
Oracle 10g OCP Completion Certification Boot Camp
| Course Length: |
7 days |
| Certifications: |
OCP |
| Number of Exams: |
1 |
|
|
- Includes roundtrip airfare and lodging (Georgia and Florida only)
- Hands-on instruction by a certified instructor
- Includes all course materials and practice exams
- Includes all certification exams
- Onsite Testing
- Breakfast and Lunch provided each day
If airfare and lodging are not required, the price is $1,000 less for 2-week courses, $750 less for 10 day courses, and $500 less for one week courses.
|
Oracle10g™ OCA must be completed before attending the Oracle10g™ OCP certification boot camp
The Oracle10g™ DBA Certified Professional is a credential for true database professionals who have the skills to set up and manage critical Oracle10g™ Database functions and the know-how to keep it running at maximum efficiency. Acquiring an OCP credential is a real professional accomplishment. The OCP credential is proof to employers, peers and the technical community that you are a skilled professional and have taken a critical step in building your career.
The Oracle OCP Hands on Requirement at Oracle University is included in the cost of this class.
Course Outline
1Z0-043 Oracle10g™ Database: 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
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 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
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
Managing Resources
- Configure the Resource Manager
- Assign users to Resource Manager groups
- Create resource plans within groups
- Specify directives for allocating resources to consumer groups
Automating Tasks with the Scheduler
- Simplify management tasks by using the Scheduler
- Create a job, program, schedule, and window
- Reuse Scheduler components for similar tasks
- View information about job executions and job instances
[ back to top ]
CED Solutions is not associated with or authorized by Oracle Corporation. Oracle is a registered trademark, and Oracle9i and Oracle10g are trademarks or registered trademarks of Oracle Corporation. The content of this website is the copyrighted property of CED Solutions, LLC.
MCSEClasses.com is your best choice for Oracle 10g OCP,
Oracle 10g OCP training,
Oracle 10g OCP certification,
Oracle 10g OCP certification boot camp,
Oracle 10g OCP boot camp,
Oracle 10g OCP certification training,
Oracle 10g OCP boot camp training,
Oracle 10g OCP boot camp certification,
Oracle 10g OCP certification course,
Oracle 10g OCP course,
training Oracle 10g OCP,
certification Oracle 10g OCP,
boot camp Oracle 10g OCP,
certification Oracle 10g OCP boot camp,
certification Oracle 10g OCP training,
boot camp Oracle 10g OCP training,
certification Oracle 10g OCP course.
|
