Oracle 10g DBA

Oracle Database 10g Installation Oracle Universal Installer System requirements Optimal Flexible Architecture (OFA) Oracle Database Creation Creating an Oracle Database using DBCA Creating an Oracle Database manually Oracle Database Architecture Oracle Database Architecture Management framework Oracle Database Operations Controlling the database Starting and stopping the agent Starting and stopping the enterprise manager database console Starting and stopping the listener Startup and shutdown the database in various modes Managing Storage Storage Structures and their relationships Creating and managing tablespaces using commands Creating and managing tablespaces using Enterprise Manager Obtaining tablespace information Creating and managing tablespaces using Oracle Managed Files (OMF) Managing Users, Privileges and Roles Creating and managing database user accounts Granting and revoking System and Object privileges Creating and managing roles Control resource usage by users Oracle Database Security Implementing standard password security features Auditing database activity Implementing Fine grained auditing (FGA) Implementing Virtual Private database (VPD) Using product user profile. Managing Schema Objects Creating and modifying tables Defining constraints Viewing the attributes of a table Viewing the contents of a table Creating indexes and views Creating and modifying Clusters Creating and modifying synonymns Creating and modifying Sequences Understanding triggers and triggering events Creating and modifying Triggers Transporting Data Manipulating data through SQL Using Export and Import utilities Using data pump utilities Using SQL Loader utility Oracle Net Services Oracle Net concepts Using Oracle Net Manager to create and configure listeners Using the listener control utility to control the Oracle Net Listener Securing the Oracle Listener Using the Oracle Net Manager to configure client and middle-tier connection Using TNSPING to test Oracle Net connectivity Oracle Shared Server Understand when to use Oracle Shared Servers Configure Oracle Shared Servers Monitoring Shared Servers Performance Monitoring Troubleshooting invalid and unusable objects Gathering optimizer statistics Viewing performance metrics Reacting to performance issues Setting warning and critical alert thresholds Collecting and using baseline metrics Using tuning and diagnostic advisors Using the Automatic Database Diagnostic Monitor (ADDM) Managing the Automatic Workload Repository Diagnostic Sources The Alert Log Viewing Alerts with EM Alerts Notification Editing Thresholds Trace Files Monitoring and Managing Memory Oracle Memory Structures Automatic PGA Memory Management Using the Memory Advisor Using Automatic Shared Memory Management to avoid long running query issues Undo Management Monitoring and administering undo Configuring undo retention Setting undo retention Guarantee Using the undo advisor Locks Management Monitoring and Resolving Lock Conflicts Detecting and resolving lock conflicts Managing deadlocks Backup and Recovery Concepts Understanding database backup, restore and recovery concepts Understanding the types of failure that may occur in an Oracle Database Tuning instance recovery Identifying the importance of checkpoints, redo log files, and archived log file Configuring ARCHIVELOG mode Database backups Creating consistent database backups Performing Online backups Performing incremental backups Automating database backups Monitoring the flash recovery area Database Recovery Recovering from loss of a control file Recovering from loss of a redo log file Recovering from loss of a data file Incomplete Recovery Needs for incomplete recovery Types of incomplete recovery Performing incomplete recovery Recovery Manager (RMAN) Backup and Recovery RMAN Settings Control File Autobackups Retention Policies Starting RMAN Issuing Recovery Manager Commands RMAN parallel backups RMAN Compressed Backups Copying the Whole Database Making Incremental Backups Monitoring RMAN Backups Performing complete and incomplete recovery. Flashback database When to Use Flashback Technology Configuring Flashback Database Monitoring Flashback Database Recovering from User Errors Recycle Bin Flashback Dropped Tables Using EM Querying Dropped Tables Flashback Versions Query Flashback Transaction Query Using Flashback Versions Query and Flashback Transaction Query Flashback Table Automatic Storage Management (ASM) ASM Concepts ASM General Architecture Creating an ASM instance Managing ASM disk groups and disks Creating tablespaces that use ASM storage Viewing ASM information Migrating a tablespace to use ASM storage