Vi ste ovdje
Overview/Description
To discuss how to manage backup and recovery in an Oracle 10g database
Target Audience
Anyone wanting to learn about Oracle Database 10g database administration
Prerequisites
An understanding of database concepts and technologies
Expected Duration (hours)
4.0
Lesson ObjectivesOracle Database 10g: Managing Backup and Recovery Release 2
recognize the types of database failure that can occur in an Oracle 10g database and identify possible solutions.
recognize how to tune instance recovery and configure a database for maximum recoverability.
recognize how to multiplex the...
Overview/Description
To demonstrate how to manage schema objects and data in an Oracle 10g database
Target Audience
Anyone wanting to learn about Oracle Database 10g database administration
Prerequisites
An understanding of database concepts and technologies
Expected Duration (hours)
3.0
Lesson ObjectivesOracle Database 10g: Managing Schema Objects and Data Release 2
identify the basic features of objects in a database schema.
recognize how to create and modify tables in an Oracle 10g database.
create, delete, and modify tables in an Oracle 10g database.
recognize the most common index types...
Overview/Description
To discuss how to manage undo data and manage lock conflicts in an Oracle database
Target Audience
Anyone wanting to learn about Oracle Database 10g database administration
Prerequisites
An understanding of database concepts and technologies
Expected Duration (hours)
1.8
Lesson ObjectivesOracle Database 10g: Managing Undo Data and Lock Conflicts Release 2
identify factors to take into consideration when managing undo.
recognize how to estimate required tablespace size and resize a tablespace in a given scenario.
calculate undo tablespace sizing and resize an undo...
Overview/Description
To recognize how various new features are used in Oracle 10g
Target Audience
Oracle 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g
Prerequisites
Experience in the administration of Oracle 8i or 9i databases
Expected Duration (hours)
2.3
Lesson ObjectivesOracle Database 10g: Miscellaneous New Features
recognize the new transaction and statistics monitoring enhancements in Oracle Database 10g.
recognize how tracing, statistical information gathering, and client and...
Overview/Description
To demonstrate how to control database performance and configure proactive database maintenance
Target Audience
Anyone wanting to learn about Oracle Database 10g database administration
Prerequisites
An understanding of database concepts and technologies
Expected Duration (hours)
2.7
Lesson ObjectivesOracle Database 10g: Monitoring and Maintenance Release 2
repair invalid and unusable objects.
detect and repair unusable indexes.
recognize how to monitor performance using dynamic performance views, Enterprise Manager, and optimizer statistics.
gather optimizer statistics...
Overview/Description
To identify the new automatic management and management infrastructure features of Oracle 10g
Target Audience
Oracle 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g
Prerequisites
Experience in the administration of Oracle 8i or 9i databases
Expected Duration (hours)
3.2
Lesson ObjectivesOracle Database 10g: New Automatic Management and Management Infrastructure Features
work with the Automatic Database Diagnostic Monitor (ADDM) in Oracle Database 10g.
perform the...
Overview/Description
To use Oracle 10g's new backup and recovery features
Target Audience
Oracle 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g
Prerequisites
Experience in the administration of Oracle 8i or 9i databases
Expected Duration (hours)
2.3
Lesson ObjectivesOracle Database 10g: New Backup and Recovery Features
recognize flash backup and recovery in Oracle Database 10g.
use new features associated with incremental backups in a given scenario.
maintain backups in Oracle Database...
Overview/Description
To discuss new data loading features in Oracle 10g
Target Audience
Oracle 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g
Prerequisites
Experience in the administration of Oracle 8i or 9i databases
Expected Duration (hours)
2.0
Lesson ObjectivesOracle Database 10g: New Data Loading Features
take the preparatory steps for transporting tablespaces from one platform to another in Oracle 10g.
identify the key processes and file issues associated with Oracle Database 10g...
Overview/Description
To use the new security and software upgrade features in Oracle 10g
Target Audience
Oracle 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g
Prerequisites
Experience in the administration of Oracle 8i or 9i databases
Expected Duration (hours)
2.7
Lesson ObjectivesOracle Database 10g: New Features in Security and Software Maintenance
create a column-level VPD policy in a given scenario.
identify the policy type to use in a given scenario.
create a fine-grained auditing...
Overview/Description
To use Oracle 10g's new VLDB support features
Target Audience
Oracle 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g
Prerequisites
Experience in the administration of Oracle 8i or 9i databases
Expected Duration (hours)
2.0
Lesson ObjectivesOracle Database 10g: New Features in VLDB Support
use bigfile tablespaces in Oracle Database 10g in a given scenario.
use Enterprise Manager to create and manage temporary tablespace groups in a given scenario.
use Enterprise...