Concentrika poppy

About us

Oracle 10G for DBAs: Part 2

Part 2 – data management and networking

About the course
Having been on part 1 of the Oracle 10G DBA training, you are now ready to deal with advanced issues of data management and networking. Also in part 2 is a detailed session on performance monitoring and optimization of the database.
A real-world view of the training is adopted, to take the delegate past the training lab and into the world of business computing. Your contribution to the labs is highly valued in this respect. Feel free to discuss issues relating to your own businesses, especially where the class as a whole would benefit from seeing what problems, and options to solve them, exist outside the lab.
Should you need examples to help you get started with individual commands or collections of actions, a resource for DBA delegates has been provided in the form of a classroom CBT web site.
Please feel free to take this away with you on floppy disk, for your own personal use. Routines are included to facilitate the complete reconstruction of the classroom environment on a machine at work that you may wish to practice on.
Should you require training in more detail in any aspect of Oracle DBA, we are able to provide you with dedicated training in specialist areas such as backup and recovery, database security, performance management, and networking databases.


Audience

  • You already have the basics of Oracle DBA and need to advance your DBA skills
  • First and second line support
  • Oracle developers wishing to know more about the underlying RDBMS
  • Storage management specialists


Prequisites
Familiarity with the theory and practice of basic Oracle database administration. Attendance on Part 1 of Oracle 10G DBA Fundamentals is strongly recommended, if you have any doubts.


Duration 4 days

1. Bulk loading and unloading of data

  • SQL*LOADER
  • EXPORT/IMPORT
  • 10G data pump expdb and impdb
  • External tables

4. Performance and monitoring
Strategies

  • Analyze command
  • UTLBSTAT/UTLESTAT
  • The stages of an SQL statement
  • Query optimisation
  • Explain plan
  • 10G cached execution plans
  • SQL Trace and TKPROF
  • Statspack
  • DBMS_STATS package
  • Buffer Cache flushing - user initiated
  • Automated checkpoint tuning CPU Costing
  • Dynamic sampling
  • New and updated 10G Optimizer hints
  • SQL Access Advisor
  

2. Data storage

  • Tables and indexes
  • Partitioning
  • Clustering
  • Large objects (LOBS)

5. Oracle networking

  • Oracle Net server side configuration
  • Configuring the Listener for IIOP and HTTP Connections
  • Oracle Net client side configuration
  • Connection Troubleshooting
  • Linked databases
  • Distributed transactions
  • Materialized views (AKA Snapshots)
  • Advanced queuing
  

3. Backup and Recovery

  • Backup and recovery strategy
  • Types of failure
  • Types of backup
  • Tuning Instance Recovery
  • Logging strategies
  • Multiple Archival Destinations and Processes
  • Describing User-Managed Backup and Recovery Operations
  • Performing Closed Database Backups
  • Performing Open Database Backups
  • Backing Up the Control File
  • Incomplete Recovery
  • Recovering from the Loss of Current Online Redo Logs
  • Recovery manager
  • Log Miner
    
Courses
schedule
Contact us