Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Self-Paced Learning    |    Online Training     


Contact Us   -   Why Choose Wintrac   -   Clients    

Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
Business Analysis
Business Intelligence
Business Objects
Business Skills
C++ programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Datawarehousing
DB2
Desktop Application Software
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Microsoft technologies
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PowerBuilder
Professional Soft Skills Workshops
Project Management
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
Oracle9i New & Advanced Features for DBAs
Oracle Training Overview

This course is designed for database administrators who will be moving to the Oracle9i database platform. This course presents the new and advanced features of the database introduced in its 9i release.

Oracle Training Prerequisites

The course Introduction To Oracle9i SQL

  • The course Introduction to Oracle9i SQL
  • The course Introduction to Oracle9i PL/SQL Language
  • The course Introduction to Oracle9i Advanced SQL
  • The course Oracle9i Database Administration DBA I
Oracle Training Audience

Target audience for this course is senior Oracle database administrators who have experience with Oracle8i and wish to exploit the advanced features introduced in Oracle9i.

Oracle Training Course duration

5 Days

Oracle Training Course outline

THE ORACLE 9I ARCHITECTURE

  • TERMINOLOGY CHANGES
  • INITIALIZATION PARAMETER FEATURES
  • V$PARAMETER Vs. V$PARAMETER2
  • ABOUT SHARED SERVER MODE
  • ADDITIONAL ARCHITECTURE CHANGES
THE ORACLE 9I SYSTEM GLOBAL AREA (SGA)
  • UTILIZING THE LARGE POOL
  • ABOUT ORACLE 9I BUFFER CACHE & SUBCACHES
  • MAKING DYNAMIC SGA CHANGES
  • THE BUFFER CACHE ADVISORY UTILITY
  • THE SHARED POOL ADVISORY UTILITY
  • CREATING MULTIPLE BUFFER POOLS
  • MONITORING ADJUSTMENTS TO THE SGA
  • MONITORING & TUNING THE PGA/UGA
  • V$SESSTAT, V$STATNAME
  • V$PROCESS
  • V$SYSSTAT
  • V$SQL_WORKAREA_HISTOGRAM
  • V$SQL_WORKAREA_ACTIVE
  • V$PGASTAT
  • V$PGA_TARGET_ADVICE
  • V$PGA_TARGET_ADVICE_HISTOGRAM
AUTOMATIC UNDO SPACE MANAGEMENT
  • CONFIGURING AUTOMATIC UNDO SPACE MANAGEMENT
  • TUNING AUTOMATIC UNDO SPACE MANAGEMENT
RESUMABLE SPACE ALLOCATION
  • MANAGING RESUMABLE SPACE ALLOCATION
  • IMPLEMENTING SPECIAL FEATURES
FLASHBACK QUERY
  • IMPLEMENTING FLASHBACK QUERY
  • ABOUT THE DBMS_FLASHBACK() PACKAGE
  • ENABLE_AT_TIME()
  • GET_SYSTEM_CHANGE_NUMBER()
  • ENABLE_AT_SYSTEM_CHANGE_NUMBER()
  • DISABLE()
  • USING THE DBMS_FLASHBACK() PACKAGE
ADVANCED TABLESPACE OPERATIONS
  • DROPPING TABLESPACE DATA FILES
  • DEFAULT TEMPORARY TABLESPACES
  • LOCALLY MANAGED TABLESPACES
  • AUTOMATIC SEGMENT SPACE MANAGEMENT
  • USING NON-STANDARD BLOCK SIZES
IMPLEMENTING ORACLE MANAGED FILES

INSTANCE RECOVERY & FAST-START

HANDLING & ANTICIPATING STUCK RECOVERIES
  • HANDLING CORRUPTION OF DATA
  • PERFORMING TRIAL RECOVERY
  • USING DBVERIFY
ADDITIONAL BACKUP & RECOVERY FEATURES

USING THE RECOVERY MANAGER (RMAN)
  • USING THE RECOVERY CATALOG
  • CONFIRMING REGISTRATION & OTHER OPERATIONS
  • USING RUN BLOCKS & SCRIPTS
  • ALLOCATING CHANNELS
  • ACCESSING RMAN VIA OEM
SERVER-MANAGED BACKUPS WITH RMAN
  • PERFORMING FULL BACKUPS
  • PERFORMING INCREMENTAL BACKUPS
EXPLORING ENHANCED RMAN CAPABILITIES
  • RESUME FAILED BACKUP OPERATIONS
  • ESTABLISHING A BACKUP RETENTION POLICY
  • SHOW ALL CONFIGURATION SETTINGS
  • GENERATE CATALOG REPORTS
  • REPORT UNRECOVERABLE
  • REPORT NEED BACKUP
  • REPORT SCHEMA
  • LIST INCARNATION
SERVER-MANAGED RECOVERY WITH RMAN
  • RECOVERY MANAGER RECOVERY
  • PERFORMING RESTORATION & FILE MEDIA RECOVERY
  • PERFORMING BLOCK MEDIA RECOVERY
STANDBY DATABASES WITH ORACLE DATA GUARD
  • ABOUT THE DATA GUARD ARCHITECTURE
  • DATA GUARD INTERFACES
DATA GUARD CONFIGURATION & OPERATIONv
  • CONFIGURING LOG TRANSPORT
  • CONFIGURING LOG APPLY
  • DATABASE SWITCHOVER OPERATIONS
  • DATABASE FAILOVER OPERATION
  • MONITORING THE STANDBY DATABASE
UTILIZING LOGMINER
  • PREPARING THE LOGMINER UTILITY
  • PERFORMING LOG MINING
  • ADD_LOGFILE()
  • START_LOGMNR()
  • END_LOGMNR()
  • EXAMINING LOGMINER OUTPUT
DATABASE RESOURCE MANAGER
  • PLANS, GROUPS AND DIRECTIVES
  • PROCEDURES AND OPERATIONS
  • A SIMPLE RESOURCE PLAN
  • CREATE_SIMPLE_PLAN() Procedure
  • SYSTEM_PLAN
  • ADMINISTERING COMPLEX RESOURCE PLANS

 
About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac


Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$


Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
 
Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy