Oracle8i New and Advanced Features For DBAs

This 5-day course considers some of the most advanced features available to database administrators. Major subject areas to be explored are: Managing the physical storage of tables & tuning the allocation of database blocks; Advanced queuing; Performance boosting capabilities which allow the size and transaction volume of databases to be scaled up dramatically using partitioned tables & indexes, bit-mapped indexes and index organized tables. Advanced administration techniques are considered such as transportable tablespaces, function based indexes, the use of logical RowIDs, the LogMiner utility and others. On course completion, students will be able to:

  • Use transportable tablespaces
  • Exploit function based indexes and logical RowIDs
  • Recover with RMAN and LogMiner
  • Build sophisticated index structures
  • Use advanced queue techniques
  • Partition large tables and indexes
key facts buy online

• code: d039eng
• 5 days
• Download outline
• Print licence available

Student edition
• A4 format
• A5 format
Instructor edition
• A4 format
• A5 format

Target audience

This course has been developed for senior Oracle Database Administrators. Students are recommended to have attended the following course or have the equivalent knowledge and experience:

  • Introduction To Oracle8i SQL & PL/SQL
  • Introduction To Oracle8i Advanced SQL & SQL*Plus
  • Oracle8i Database Architecture & Administration - DBA I
  • Oracle Backup & Recovery Strategies
  • Oracle Tuning & Troubleshooting
Course content

Partitioned tables and indexes

Advanced quering (Part I)

Advanced queuing (Part II)

Advanced index

Advanced table management features

Database migration

Advanced program units

Large objects (LOBS)

Manipulating large objects (LOBS)

Object database features

Collections

Advanced database administration Manage transportable tablespaces • Function based indexes • Logical ROWIDS

Java in the database About the Oracle JSERVER option • Using the JSERVER option • Administering and tuning JSERVER

Recovery Manager (RMAN) Introducing Recovery Manager • Concifugration decisions • Using the recovery catalog • Backups with Recovery Manager • Restores with Recovery Manager • Recoveries with Recovery Manager • About generating reports • About scripts • Create script • Execute script

The LOGMINER About LOGMINER • Using the LOGMINER procedures • Using the results of the LOGMINER analysis

About data warehousing About data warehouse administration • Understanding warehouse concepts and terms

Using materialized views Materialized views in an Oracle database • Defining the materialized view • Implementing materialized views • Create materialized view format • COMPLETE Refresh • FAST Refresh • FORCE Refresh • ALWAYS Refresh

About Courseware Company :: Instructor-led training courseware :: Self-study solutions :: Buy online today

A gtslearning business division :: gtslearning CompTIA learning solutions ::Contact us :: Site map
© gtslearning, 2008. All rights reserved. Ownership of all trademarks and service marks is observed and respected.