New York City

(Change City)

Register | Login

 

Details:

Price

(Contact Us)

Area Served

New York

Location

New York, 10001
View Map

Phone

917-775-5176

Description:

ORACLE DBA ONLINE TRAINING VIRTUAL CLASS ROOM



Hi all,

Our online training process covers Oracle DBA topics as listed below. In addition to the below we will cover still some more topics.

HIGHLIGHTS OF MY TRAINING:


1. You will get trained in Oracle DBA not just as a single tool in Oracle official training.
2. You will have support in the resume preparation and also FAQ in the interview point of view.
3. You will have support if you have doubts by phone or e-mail once you are in the job.

I request you people to attend the first 2 classes and if you are not satisfied with the price, curriculum, my PROFICIENCY in ORACLE DBA you can dropout.


1. Oracle Architectural Components


Oracle Server
Oracle Instance
Establishing a Connection and Creating a Session
Oracle Database
Physical Structure
Memory Structure
System Global Area (SGA)
Shared Pool
Library Cache
Data Dictionary Cache
Database Buffer Cache
Redo Log Buffer Cache
Large Pool
Java Pool
Program Global Area (PGA)
Process Structure
User Process
Sever Process
Background Processes
Database Writer (DBWn)
Log Writer (LGWR)
System Monitor (SMON)
Process Monitor (PMON)
Checkpoint (CKPT)
Archiver (ARCn)
Logical Structure




2 Managing an Oracle Instance


Initialization Parameter Files
PFILE initSID.ora
PFILE Example
SPFILE spfileSID.ora
Creating an SPFILE
SPFILE Example
Oracle Managed Files
Oracle Managed File Example
Starting UP a Database
STARTUP Command
The ALTER DATABASE Comand
Opening a Database in Restricted Mode
Opening a Database in Read-Only Mode
Shutting Down the Database
Shutdown Options
Managing an Instance by Monitoring Diagnostic Files
Alert Log File
Background Trace Files
User Trace File
Enabling or Disabling User Tracing


3 Maintaining the Control File


Control File
Control File Contents
Multiplexing the Control File Using SPFILE
Multiplexing the Control File Using init.ora
Managing Control Files with OMF
Obtaining Control File Information


4 Maintaining Redo Log Files


Using Redo Log Files
Structure of Redo Log Files
How Redo LogsWork
Forcing Log Switches and Checkpoints
Adding Online Redo Log Groups
Adding Online Redo Log Members
Dropping Online Redo Log Groups
Dropping Online Redo Log Members
Clearing, Relocating, or Renaming Online Redo Log Files
Online Redo Log Configuration
Managing Online Redo Logs with OMF
Obtaining Group and Member Information
Archived Redo Log Files






5 Storage Structure and Relationships


Types of Segments
Storage Clause Precedence
Extent Allocation and Deallocation
Used and Free Extents
Database Block
Database Block Contents
Block Space Utilization Parameters
Data Block Management
Automatic Segment-Space Management
Configuring Automatic Segment-Space Management
Manual Data Block Management
Block Space Usage
Data Dictionary Views
Obtaining Storage Information


6 Managing Indexes


Classification of Indexes
B-Tree Index
Bitmap Index
Comparing B-Tree and Bitmap Indexes
Creating Normal B-Tree Indexes
Creating Indexes: Guidelines
Creating Bitmap Indexes
Changing Storage Parameters for Indexes
Allocating and Deallocating Index Space
Rebuilding Indexes
Online Rebuild of Indexes
Coalescing Indexes
Checking Index Validity
Dropping Indexes
Identifying Unused Indexes
Obtaining Index Information


7 Backup and Recovery
Backup and Recovery Overview
Instance and Media Recovery Structures
Configuring the Database Archiving Mode
Oracle Recovery Manager Overview and Configuration
User-Managed Backups
RMAN Backups
User-Managed Complete Recovery
RMAN Complete Recovery


For more information, Please call me at 917-775-5176 or email me at
ankith38@gmail.com