Webfire Themes Weebly Templates
    Mapple Jaipur
    info@mapple.ac.in
        mapple.edusoft@gmail.com
    Call us :  8233-25-2525
                          8233-54-5555
    • Home
    • Profile
      • Meet the Team
      • Partner with us
      • Webmail
      • Career >
        • Code of Conduct
    • Services
    • Training
      • Online Registration
      • IT Training >
        • Oracle Training >
          • Oracle 11g Database (DBA) >
            • 11g: Introduction to SQL
            • 11g: Administration Workshop 1
            • 11g: Administration Workshop 2
          • Oracle 10g Database (DBA) >
            • 10g: Introduction to SQL
            • 10g: Administration Workshop 1
            • 10g: Administration Workshop 2
          • Oracle 9i Database (DBA) >
            • 9i: Introduction to SQL
            • 9i: Administration Fundamentals 1
            • 9i: Administration Fundamentals 2
            • 9i: Performance Tuning
        • Big Data >
          • Introduction to Big Data
          • Big Data Essentials
        • Java Training >
          • Java Fundamentals SE6 (OCJA)
          • Java Fundamentals SE7 (OCJA)
          • Java Fundamentals SE8 (OCJA)
          • Java SE6 (OCJP)
          • Java SE7 (OCJP)
          • Java SE8 (OCJP)
          • Java SE 7 New Features
          • Java SE 8 New Features
          • Java EE6 Developing App (OCWCD)
          • Java EE6 Servlets & JSP (OCWCD)
          • Java EE6 EJB TECHNOLOGY (OCBCD)
        • PHP With MySQL >
          • PHP Training & MySQL
          • MySQL for Developers
        • Ethical Hacking
        • SEO Training
      • SSC Training >
        • SSC SYLLABUS TIER-I >
          • QUANTITATIVE APTITUDE
          • GENERAL MENTAL ABILITY
          • ENGLISH
          • COMPUTER AWARENESS
          • GENERAL KNOWLEDGE
    • Certification
    • Online Test
      • Admin
    • Alliances
    • Placement
    • Contact Us
      • Bank Details

    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

    OUR SERVICES : 

    IT Training & Skill Development
    International Certification
    Earn & Learn
    Software & Website Development
    Business Support Services
    Infrastructure leasing
    Franchise

    Company :

    About Us
    Contact Us
    Terms and Conditions
    Privacy Policy
    Disclaimer of Warranty

    Alliances :

    Oracle - Java - WDP
    EC - Council
    MeritTrac Services Pvt. Ltd
    Aspiring Minds
    Hughes Communication India Ltd.

    Contact US

    • Mapple Edusoft Private Limited
      78, 3rd Avenue, Goms Defence Colony,
      Vaishali Nagar, Jaipur - 302021
      Rajasthan
    • +91-8233-54-5555
      +91-8233-25-5555
    • info@mappleedusoft.com
    • www.mappleedusoft.com

    Back to top