INTRODUCTION
DBA (Database Administrator) course prepares you for the Oracle Certified Associate (OCA) and Oracle Certified Professional (OCP) certifications as well as train you in the skills necessary to administer database and database servers. . Oracle Database Administration (DBA) Services from SRAE currently enables our clients to reduce IT costs and increase the resilience of critical Oracle-based applications.Architecture & Configuration
. Overview of Oracle DBA tasks
. Instance Architecture
. Oracle Instance Internals
. Using SQL*Plus for DBA management
. Control file, UNDO and REDO management
. User and privilege management
Oracle database management
. Overview of instance management
. Initialization file management
. Oracle*Net configuration
. Data buffer configuration & sizing
. Shared pool and PGA configuration & Sizing
. Troubleshooting network connectivity
Oracle object management
. Oracle tables, views and materialized views
. Oracle indexes
. Oracle constraints
. Schema, File & tablespace management
. Database Maintenance
. Oracle DBA Utilities
Monitoring Oracle
. Dictionary and v$ views
. Table & index monitoring
. workload & trend monitoring
. Instance monitoring
. Oracle environment monitoring
. STATSPACK and AWR performance management
Performance Management
. Bottleneck performance analysis
. Instance Tuning
. SQL and CBO behavior
. Tracing SQL Execution
. SQL Execution Internals
. SQL Tuning
. Oracle High Availability tools
. Backup & Recovery