Oracle Database 10g: Administration Workshop 2

What you will learn:
Oracle DBAs manage the industries most advanced information systems and command some of the highest salaries. This course advances your success as an Oracle professional in the area of database administration.

In this class, you'll learn how to configure an Oracle database for multilingual applications. Students will practice various methods of recovering the database, using RMAN, SQL, and Flashback technology. Tools to monitor database performance and what steps to take to improve database performance are also covered in this course. Students will also learn how to use various database technologies, such as Resource Manager, the Scheduler, and Automatic Storage Management (ASM). The lesson topics are reinforced with structured hands-on practices and a workshop. This course is designed to prepare you for the corresponding Oracle Certified Professional exam.

Why Oracle 10 g training from Mapple Edusoft :
  • Official Course-ware from Oracle University.
  • Authorized Structured Oracle Training in Jaipur.
  • Highly Qualified Java Industry Experts as Trainer.
  • Hands on experience on Oracle Software.
  • Course Completion Certificate From Oracle University.
  • Discount Vouchers for International Exams.
  • 10 Full-length Online Mock Tests (Real-life Oracle® Exam) per Module.

Prerequisites :
  • Oracle Database 10g: SQL Fundamentals I
    Oracle Database 10g: Administration Workshop I 

Course Topics :
Using Globalization Support
    Datetimes with Timezones
    Specifying Language-Dependent Behavior
    Locale Variants
    Linguistic Sorting
    Case and Accent Insensitive Sorts
    Linguistic Comparisons
    Obtaining Information about the Current NLS Configuration
Securing the Oracle Listener
    Listener Password Authentication
    Controlling Database Access
    Securing the EXTPROC Service Entry
Configuring Recovery Manager
    Using a Flash Recovery Area with RMAN
    Setting Parameters for RMAN
    Starting RMAN
    Configuring Persistent Settings for RMAN
    Control File Autobackups
    Retention Policies
Using Recovery Manager
    Issuing Recovery Manager Commands
    Parallelization of Backup Sets
    Compressed Backups
    Copying the Whole Database
    Making Incremental Backups
    Block Change Tracking
    Incrementally Updating Backups
    Monitoring RMAN Backups
Diagnostic Sources
    The Alert Log
    Viewing Alerts with EM
    Alerts Notification
    Editing Thresholds
    Trace Files
Recovering from non-critical losses
    Creating New Temporary Tablespace
    Recreating Redo Log Files
    Recovering an Index Tablespace
    Read-Only Tablespace Recovery
    Loss of Password Authentication File
Database Recovery 
    Recovery Steps
    User-Managed Recovery Procedures: RECOVER Command
    Types of incomplete recovery
    Incomplete Recovery Best Practices
    Recovery Using EM
    Simple Recovery Through RESETLOGS
    Point-in-time recovery using RMAN
Flashback Database
    When to Use Flashback Technology
    Configuring Flashback Database
    Monitoring Flashback Database
    Best Practices for the Database and Flash Recovery Area
    Flash Recovery Area Space Usage
    Flashback Database Examples
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
    Using EM To Flashback Tables
Dealing with Database Corruption
    What is block corruption?
    Interpreting DBVERIFY
    The ANALYZE command
    How to Handle Corruptions
    The DBMS_REPAIR Package
    Block Media Recovery (BMR)
    Detecting Database Corruptions Using DBVERIFY
    Using RMAN to Repair Corrupt Blocks
Automatic Database Management
    Automatic Optimizer Statistics Collection
    Workload Repository
    Database Control and Advisors
    Using the SQL Tuning Advisor
    Using the SQL Access Advisor
    Automatic Undo Retention Tuning
Monitoring & Managing Storage
    Redo Logfile Size Advisor
    Resumable Statements
    Tablespace Space Usage Monitoring
    Accessing the Segment Advisor
    Shrinking Segments Using SQL
    Segment Resource Estimation
    Monitoring Index Space
    Identifying Unused Indexes
Automatic Storage Management
    ASM Concepts
    ASM General Architecture
    Creating an ASM instance
    Creating tablespaces that use ASM storage
    Viewing ASM information
    Migrating a tablespace to use ASM storage
Monitoring & Managing Memory
    Oracle Memory Structures
    Automatic PGA Memory Management
    Using the Memory Advisor
    Using Automatic Shared Memory Management to avoid long running query issues
Managing Resources
    Creating a New Resource Plan
    Creating Resource Consumer Groups
    Assigning Users to Resource Consumer Groups
    Adaptive Consumer Group Mapping
    Using Sub-Plans to limit CPU Utilization
    Administering the Resource Manager
    Resource Plan Directives
Automatic Tasks with the Scheduler
    Creating a Scheduler Job
    Using Scheduler Programs
    Creating and Using Schedules
    Creating a Job Class
    Prioritizing Jobs within a Window
    Viewing Job Execution Details
    Creating a job that runs a program outside of the database
Certificate From Oracle University :
Oracle Training in Jaipur - DBA, Developer - OCA -OCP
Oracle Training in Jaipur - DBA, Developer - OCA -OCP
Authorized Oracle 10g Training in Jaipur @ Mapple Edusoft