Oracle 10g Training
Oracle10g New Features Overview - 1 Day Lecture
Overview of the major new features available in Oracle 10g Release 1 and Release 2, focusing on explaining the purpose and use of new features within the context of hands-on working examples. Covers enhancements to Oracle 10g Backup and Recovery, Flashback features, Job Scheduler, Automatic Storage Management (ASM), SQL, Performance Tuning, PL/SQL, Security, SQL*Plus, Utilities and other major enhancements.
Online Class ScheduleRequest a Class |
Request More Info |
Buy Course Book |
Downloads | Online Books | Topic Summary | Print Version
Class Description:
Topic Summary
- Oracle10g Backup and Recovery Enhancements
- Flash Recovery Area: Concepts
- Flash Recovery Area: Benefits
- Flash Recovery Area: Configuration
- Flash Recovery Area: Monitoring
- Simplified Recovery Through RESETLOGS
- Architectural Changes
- Compressed Backups
- Change Tracking
- Incrementally Updated Backups
- New V$ Views
- Encrypted Backups
- DURATION Parameter
- More RMAN Enhancements
- User-Managed Enhancements
- Oracle Backup
- Lesson Summary
- Flashback Features
- Flashback Evolution
- Flashback Setup
- Flashback Version Query
- Flashback Version Query
- FLASHBACK_TRANSACTION_QUERY View
- Flashback Table Concepts
- Flashback Table Prep
- Flashback Table: Undo Application Changes
- Flashback Table Notes
- Flashback Table: Recover Dropped TABLE
- Example: Recover from DROP TABLE
- LIFO to the Recycle Bin
- Purging Recycle Bin
- Flashback Database
- Configure Database
- Flashback Database: Example
- R2 Flashback Database
- Lesson Summary
- Automatic Storage Management
- Introducing ASM
- Automated S.A.M.E.
- Highlights
- ASM Instance Architecture
- ASM Install Tips
- Starting ASM
- ASM Disks
- ASM Diskgroups
- ASM Failgroups
- Creating Diskgroup
- Altering Diskgroup
- Referencing Disk Group
- ASMCMD
- More R2 Enhancements
- Lesson Summary
- Resources
- SQL Enhancements
- Regular Expressions
- REGEXP_LIKE
- Common Metasymbols
- Perl Expressions
- Matching Sets and Repeaters
- Backreferences
- Summary: Regular Expressions
- Case-Insensitive Sort
- Case-Insensitive Search
- Accent-Insensitive Sort and Search
- Effect on Index Use
- Text Literal Quote Character
- MERGE Enhancements
- MERGE Examples
- Partition Outer Join
- MODEL Clause Concepts
- MODEL Components
- MODEL: Example
- ORA_ROWSCN
- ORA_ROWSCN Use
- New Datatypes
- LOB Enhancements
- New Functions
- RETURNING Aggregates
- CONNECT_BY_ROOT
- CONNECT BY: NOCYCLE
- CONNECT BY: Pseudocolumns
- COMMIT Enhancements
- Miscellaneous SQL Features
- Introduction to XQuery
- Oracle XQuery Support
- XQuery Examples
- Lesson Summary
- Job Scheduler
- Introduction
- Scheduler Components
- Job Scheduling
- Control Resources
- Monitoring Jobs
- More Features
- Example: Create Schedule
- Example: Create Job
- Example: OS Script
- DBA_SCHEDULER_JOBS
- DBA_SCHEDULER_SCHEDULES
- Other Dictionary Views
- Miscellaneous
- Scheduler Privileges
- Lesson Summary
- Resources
- Performance and Tuning I: General Enhancements
- Automatic Shared Memory Management
- Auto SGA Demo
- V$SESSION Enhancements
- Finding Blockers
- Enterprise Manager
- Tuning with EM
- EM Database Control
- EM Grid Control
- Automatic Optimizer Statistics
- DBMS_STATS
- Rule-Based Optimization
- CBO: Hash Group By
- CBO: Costed Transformations
- Hints
- SQL*Plus AUTOTRACE
- PL/SQL Performance
- End-to-End Tracing
- Other Trace Enhancements
- Miscellaneous Features
- Other Release 2 Enhancements
- Lesson Summary
- Performance and Tuning II: New Statistics
- New Performance Data
- Metrics
- Metric Thresholds
- Server-Generated Alerts
- Time Model Statistics
- V$SESS_TIME_MODEL
- Database Time
- Active Session History
- V$ACTIVE_SESSION_HISTORY
- DBA_HIST_ACTIVE_ SESS_HISTORY
- Wait Classes
- V$SESSION_WAIT_CLASS
- V$SESSION_WAIT_HISTORY
- V$EVENT_HISTOGRAM
- V$FILE_HISTOGRAM
- Lesson Summary
- Performance and Tuning III: AWR & Advisors
- Introduction to AWR
- AWR Snapshots
- Controlling AWR
- AWR Views
- AWR Reporting
- Tuning Advisors
- Introduction to ADDM
- ADDM Report Excerpt
- ADDM Findings
- Enabling ADDM
- SQL Tuning Advisor
- STA Interfaces
- Input to SQL Tuning Advisor
- Running STA
- STA Demo
- SQL Profiles
- SQL Profile Demo
- Other AWR-Based Advisors
- Other Advisors
- Lesson Summary
- 10g PL/SQL Enhancements
- Performance: Compiler
- Optimization Comparison
- Compiler Warnings
- Native Compilation Review
- Native Compilation: New Stuff
- Conditional Compilation
- FORMAT_ERROR_BACKTRACE
- GET_CPU_TIME
- FORALL Improvements
- Regular Expressions
- Quoting Mechanism
- Introducing UTL_MAIL
- UTL_MAIL SET UP
- UTL_MAIL EXAMPLE
- Nested Table Enhancements
- New and Revised Packages
- Lesson Summary
- Security Enhancements
- CONNECT Role
- FGAC Review
- VPD Policy Types Review
- 10g VPD Policy Types
- Column-Level VPD
- 10g VPD Example
- Fine Grained Auditing Review
- Review: Create FGA Policy
- Review: Display Audited Activity
- 10g Auditing Enhancements
- DBMS_CRYPTO
- Transparent Data Encryption
- Lesson Summary
- SQL*Plus Enhancements
- Predefined Variables
- Recycle Bin
- SPOOL Enhancements
- SQL*Plus AUTOTRACE
- Miscellaneous
- Lesson Summary
- Tablespace, Table and Segment Management
- SYSAUX
- BIGFILE Tablespace
- SMALLFILE Tablespace
- Default Tablespace
- Rename Tablespace
- Temp Tablespace Groups
- Transportable Tablespace
- Predicting Object Growth
- Online Table Redefinition
- Online Segment Shrink
- Shrink: 9i versus 10g
- How to Shrink
- Lesson Summary
- Utility Enhancements
- Introducing Data Pump
- Server-Based Utility
- Major Differences
- Data Pump Modes
- Data Pump Access Methods
- Export Example
- Import Example
- Monitoring Jobs
- Filtering
- Remap & Transformation
- Flashback
- expdp Features
- impdp Features
- Network Export / Import
- Network Import Example
- DBMS_DATAPUMP
- Data Pump Dictionary
- Enterprise Manager
- Datapump Resources
- External Tables
- External Table Resources
- Logminer Enhancements
- Lesson Summary
- Miscellaneous Enhancements
- Guaranteed Retention
- Rollback Monitoring
- New Connect String
- High Watermark Statistics
- Database Feature Usage
- Deprecated Parameters
- Release 1 Parameters
- Release 2 Parameters
- DROP DATABASE
- Lesson Summary

