OCP - Oracle Certified Professional

Database Recovery  - odtwarzanie bazy danych
- Recover the control file
- Explain reasons for incomplete recovery
- Perform incomplete recovery using EM (enterprise manager) - recovery z EM
- Perform incomplete recovery using RMAN - używając RMAN-a
- Perform incomplete recovery using SQL - z linii poleceń, polecenia SQL

- Perform database recovery following a RESETLOGS operation

Flashback Database

- Determine which flashback technology to use for each recovery situation
- Configure and use 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

Monitoring and Managing Storage - zarządzanie i monitorowanie 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

Automating Tasks with the Scheduler - ASM

- 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 - zarządzanie i monitorowanie pamięci

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