|
Provided by: Ahana Systems and Solutions (P) Ltd Shell Scripting Online TrainingPerfomance Tuning |
![]() |
Training
Provided by Ahana Systems and Solutions (P) Ltd
Oracle Database Administration
Oracle database training equips individuals to install, maintain, troubleshoot and fine-tune all aspects of an Oracle database.
Our Oracle database training explores Oracle's unique ability to deliver the benefits of grid computing with more self-management and automation. Our Oracle Database Administrator Certification track combines training, experience and testing to ensure you have a strong foundation and expertise in the industry's most advanced database management system.
Oracle DBA professionals need a solid knowledge of the Linux/ Unix environment and functionality to successfully implement, administer and maintain Oracle software. To help these professionals get the recognition that they need our training includes excessive coverage in the Linux space. Oracle DBA track training is delivered on Linux/ unix environments unlike others, which imparts knowledge and expertise in Linux/ Unix OS administration and managing Oracle database environments on Linux/ Unix platform
|
|
||||||||||
Shell Scripting Online Training
Oracle 10g Database Administration
Course Contents:
INTRODUCTION
How DBAs Spend Their Time
Oracle Database 10g Manageability Goals
Oracle Database 10g Solution: Self-Managing Database
Grid Computing
Oracle Database 10g: The Database for the Grid
INSTALLATION
Installation Performance Enhancements
Installation New Feature Support
Automatic pre & post install validations
CD pack contents
SERVER CONFIGURATION
Database Features Usage Tracking
Automatic Enterprise Manager Configuration
Simplified Initialization Parameters
Simplified Database Install
LOAD AND UNLOAD DATA
Cross-platform Transportable Tablespaces
DataPump Export and Import Utilities
AUTOMATIC MANAGEMENT
Automatic Checkpoint Tuning
Automatic Database Diagnostic Monitor
Automatic Shared Memory Tuning
Automatic Optimizer Statistics Collection
Automatic Undo Retention
MANAGEABILITY INFRASTRUCTURE
Advisory Framework
Automatic Routine Administration Tasks
Server-generated Alerts / Threshold-based Alerts
Automatic Workload Repository
THE SCHEDULER
Core Scheduler Features
Privileges for Scheduler Components
Calendaring Expressions
Advanced Scheduler Concepts
SPACE MANAGEMENT
Automatic segment Advisor & Sorted Hash Clusters
New Segment Resource Estimation
Online Segment Shrink
Proactive Tablespace Management
Undo Advisor
BIGFILE TABLESPACE
Enhanced Partition Management in Enterprise Manager
Global Partitioned Indexes - Hash Partitioning
Local Partitioned Indexes Manageability Improvements
Temporary tablespace groups
Bitmap index enhancements
RMAN ENHANCEMENTS
Flash Backup and Recovery
Backup Compression
DROP DATABASE
Automatic Channel Failover for Backup & Restore
Incrementally Updated Backups
Simplified Recovery Through Resetlogs
FLASHBACK ANY ERROR
Flashback Database
Flashback Table
Flashback Versions Query
Flashback Transaction Query
Flashback Drop
Recycle Bin
GENERAL STORAGE MANAGEMENT
Rename Tablespace
Redo Logfile Sizing Advisor
SYSAUX Tablespace
Copying Files using the Database Server
Automatic Storage Management
ASM General Architecture
TRANSACTION MONITORING
End-to-End Tracing
Resumable Space Allocation Enhancements
Logminer enhancements
Resumable Space Allocation Enhancements
SQL TUNING ADVISOR
End-to-End Tracing
Logminer enhancements
Resumable Space Allocation Enhancements
Course Contents:
INTRODUCTION
How DBAs Spend Their Time
Oracle Database 10g Manageability Goals
Oracle Database 10g Solution: Self-Managing Database
Grid Computing
Oracle Database 10g: The Database for the Grid
INSTALLATION
Installation Performance Enhancements
Installation New Feature Support
Automatic pre & post install validations
CD pack contents
SERVER CONFIGURATION
Database Features Usage Tracking
Automatic Enterprise Manager Configuration
Simplified Initialization Parameters
Simplified Database Install
LOAD AND UNLOAD DATA
Cross-platform Transportable Tablespaces
DataPump Export and Import Utilities
AUTOMATIC MANAGEMENT
Automatic Checkpoint Tuning
Automatic Database Diagnostic Monitor
Automatic Shared Memory Tuning
Automatic Optimizer Statistics Collection
Automatic Undo Retention
MANAGEABILITY INFRASTRUCTURE
Advisory Framework
Automatic Routine Administration Tasks
Server-generated Alerts / Threshold-based Alerts
Automatic Workload Repository
THE SCHEDULER
Core Scheduler Features
Privileges for Scheduler Components
Calendaring Expressions
Advanced Scheduler Concepts
SPACE MANAGEMENT
Automatic segment Advisor & Sorted Hash Clusters
New Segment Resource Estimation
Online Segment Shrink
Proactive Tablespace Management
Undo Advisor
BIGFILE TABLESPACE
Enhanced Partition Management in Enterprise Manager
Global Partitioned Indexes - Hash Partitioning
Local Partitioned Indexes Manageability Improvements
Temporary tablespace groups
Bitmap index enhancements
RMAN ENHANCEMENTS
Flash Backup and Recovery
Backup Compression
DROP DATABASE
Automatic Channel Failover for Backup & Restore
Incrementally Updated Backups
Simplified Recovery Through Resetlogs
FLASHBACK ANY ERROR
Flashback Database
Flashback Table
Flashback Versions Query
Flashback Transaction Query
Flashback Drop
Recycle Bin
GENERAL STORAGE MANAGEMENT
Rename Tablespace
Redo Logfile Sizing Advisor
SYSAUX Tablespace
Copying Files using the Database Server
Automatic Storage Management
ASM General Architecture
TRANSACTION MONITORING
End-to-End Tracing
Resumable Space Allocation Enhancements
Logminer enhancements
Resumable Space Allocation Enhancements
SQL TUNING ADVISOR
End-to-End Tracing
Logminer enhancements
Resumable Space Allocation Enhancements
About The Training Provider: Ahana Systems and Solutions (P) Ltd
Ahana Systems and Solutions (P) Ltd - Oracle9i DBA
Oracle 10g DBA
Oracle 10g RAC
Sybase DBA
ASE DBA
Sybase Replication DBA
Oracle DBA
MSSQL DBA
MySQL DBA
Perl scripting
Shell scripting
Clearcase Administration
Linux Administration
VMWare
Windows Administration
Our In-house training is aimed at individuals who want to build their career in IT infrastructure field. Its mainly aimed at studends who are in the verge of...

