|
Online
Oracle Video Schooling
DBA
Please
read the User
Agreement and Copyright Violation
- Copyright
© 1999-2007
Hands-On Oracle9i Database: Fundamentals I
DBA001-The most important Dictionary Views
DBA002-Startup and Shutdown the database
DBA003-Multiplexing controlfiles
DBA004-Reading the ALERT file
DBA005-Changing the database mode
DBA006-Server Parameter File-SPFILE
DBA007-Configure the database to the archive mode
DBA008-Maintainiing and Relocating the Redo Log files
DBA009-Multiplexing and Maintaining the Online Redo Log files
DBA010-Maintaining Tablespace and Datafiles
DBA011-Maintaining a TEMPORARY tablespace
DBA012-Maintaing a Tablespace
DBA013-Managing Storage Structures
DBA014-Maintaining and Configuring UNDO tablespace
DBA015-Maintaining and Configuring an UNDO tablespace manually
DBA016-Creating and Maintaining a TEMPORARY table
DBA017-Detecting ROW Migration and Chaining
DBA018-Monitoring an object usage
DBA019-EXCEPTIONS INTO EXCEPTIONS
DBA020-Maintaining user's account and profile
DBA021-Auditing a database
DBA022-Creating a new database |
Hands-On Oracle9i Database: Fundamentals II
|
DBAx01-Memory Space Allocation on the fly
DBAx02-Oracle Background Processes
DBAx03-Multiplexing the Control Files (Advanced)
DBAx04-Configuring the Database Archive mode (Advanced)
DBAx05-Maintaining Redo Log Files (Advanced)
DBAx06-Duplexing Archived Online Redo Log Files (Advanced)
DBAx07-User Managed COLD or OFFLINE Backup
DBAx08-User Managed HOT or ONLINE Backup
DBAx09-User Managed Tablespaces and Datafiles Backup
DBAx10-User Managed Tablespace Recovery
DBAx11-User Managed Logical Backup and Recovery
DBAx12-RMAN Managed user and repository (Oracle9i)
DBAx13-Use of the RMAN commands
DBAx14-Configuration of the RMAN tool
DBAx15-Using the RMAN backup utility
DBAx16-RMAN Managed Tablespace Recovery
DBAx17-RMAN Managed Complete Backup
DBAx18-RMAN Managed incomplete database recovery scenario
DBAx19-RMAN Managed incomplete database recovery
DBAx20-RMAN Managed the LIST and REPORT commands
DBAx21-Configuring a LISTENER using the Net Manager Tool
DBAx22-Configuring a Service Name using the Net Manager Tool |
Hands-On Training Performance Tuning
|
PRF001-Why tuning
PRF002-Memory Space Allocation
PRF003-Sizing the Shared Pool
PRF004-Sizing the Buffer Cache
PRF005-Measuring the Buffer Cache Hit Ratio
PRF006-Monitor and size the Redo Log Buffer
PRF007-Database I/O Problem
PRF008-Optimizing Sort Operations
PRF009-Diagnosing Contention for Latches
PRF010-Tuning Rollback or UNDO Segment
PRF011-Monitoring and Detecting Lock Contention
PRF012-Optimizing a SQL Statement
PRF013-Diagnostic and Tuning Tools (STATSPACK) |
Hands-On Training Oracle Enterprise Manager (OEM)
|
OEM001-Descovering a Server Node
OEM002-Managing Users
OEM003-Managing Roles
OEM004-Managing Profiles
OEM005-Managing Tablespaces and Datafiles
OEM006-Obtaining a database structure
OEM007-Managing Database Objects
OEM008-Optimizing a SQL statement
OEM009-Managing Groups and Events
OEM010-Obtaining a Database Information
OEM011-Obtaining a Memory Statistical
OEM012-Obtaining a SQL Statement Information
OEM013-Detecting a session lock problem
OEM014-Obtaining Disk I/Os
OEM015-Scheduling a database backup
OEM016-Performing a logical backup and restore |
|