Oracle OCP 10g Certification Course - Unisoft India

• Outline the Oracle Architecture and its main Components 
• Explain the Oracle instance architecture

• Identify common database administrative tools available to a DBA
• Use optimal flexible architecture  
• Install software with Oracle Universal Installer  
• Identify and configure commonly used environment variables  
• Use Installer Log

• Use DBCA to Create a database  
• Use DBCA to Delete a database  
• Use DBCA to manage templates 

• Use Enterprise Manager 
• Use SQL*Plus and iSQL*Plus to access the Oracle Database  
• Modify database initialization parameters  
• Describe the stages of database startup  
• Describe the database shutdown options  
• View the database alert log  
• Use dynamic performance views

• Describe how table row data is stored in blocks
• Define the purpose of tablespaces and data files  
• Explain space management in tablespaces  
• Create tablespaces  
• Manage tablespaces: alter, drop, take offline, put online, add data files, make read-only or read-write, generate DDL  
• Obtain tablespace information  
• Explain key features and benefits of ASM

• Create and manage database user accounts
• Create and manage roles  
• Grant and revoke privileges  
• Create and manage profiles

• Create and modify tables 
• Define constraints and states of constraints 
• Dropping and truncating tables
• Create and use B-Tree and Bitmap indexes
• Create Views  
• Create sequences  
• Use data dictionary 

• Manipulate data through the use of SQL 
• Identify and administer PL/SQL objects  
• Describe triggers and triggering events  
• Define levels of locking  
• List possible causes of lock conflict  
• Monitor and resolve lock conflicts 

• Monitor and administer undo 
• Configure undo retention  
• Describe the relationship between undo and transactions  
• Size the undo tablespace 

• Apply the principle of least privilege 
• Audit database activity  
• Implement Fine-Grained Auditing 

• Use Database Control to Create additional listeners 
• Use Database Control to Create Oracle Net service aliases  
• Control Oracle Net Listeners  
• Identify when to use shared servers versus dedicated servers

• Gather optimizer statistics
• Manage the Automatic Workload Repository 
• Use the Automatic Database Diagnostic Monitor (ADDM)  
• Set warning and critical alert thresholds  
• React to performance issues 

• Use enterprise manager to view performance
• Tune SQL by using SQL tuning advisor 
• Tune SQL by using SQL access advisor  
• Use automatic shared memory management
• Use the memory advisor to size memory buffer

• Describe the types of failure that may occur in an Oracle Database 
• Identify the importance of checkpoints, redo log files, and archived log files  
• Tuning instance recovery  
• Configure a database for recoverability  
• Configure ARCHIVELOG mode 

• Create consistent database backups 
• Back up your database without shutting it down 
• Create incremental backups  
• Automate database backups  
• Backup a control file to trace  
• Monitor flash recovery area

• Recover from loss of a Control file  
• Recover from loss of a Redo log file  
• Recover from loss of a system-critical data file 
• Recover from loss of a non system-critical data file 

• Describe flashback database
• Resotore the table contents to a specific point in time
• Recover from a dropped table
• Use Flashback Query to view the contents of the database as of any single point of time
• View transaction history or row with flashback transaction query

• Describe the general architecture of Data Pump
• Use Data Pump export and import to move data between Oracle databases 
• Load data with SQL Loader
• Use external tables to move data

Oracle Database 10g: Administration Workshop II (Course Content)

• Configure database parameters that affect RMAN operations
• Change RMAN default settings with CONFIGURE 
• Manage RMAN's persistent settings 
• Start RMAN utility and allocate channels

• 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

• 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

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

• 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

• Recover temporary tablespaces
• Recover a redo log group member 
• Recover index tablespaces 
• Recover read-only tablespaces 
• Recreate the password file

• 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

• 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

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

• 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

• 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

• Configure the Resource Manager
• Assign users to Resource Manager groups 
• Create resource plans within groups 
• Specify directives for allocating resources to consumer groups

• 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