Oracle Administration
(6 Weeks Course)
Topics
Oracle Server Architecture
Overview
Back ground processes
Markup and Shutdown an Instance
Mount database
Open database
Alter database
Shutdown database
Create A Database
determine tablespaces
store datafile
create database procedure
connect to the database
add a control file
Manage Database Storage
database block
manage Table
extents
Manage Database Segment
create Index
manage Cluster
validate Structure
Manage Database Users
create users
monitor users
Control Database Privileges
system privileges
revoke system privileges
Backup and Recover the Database
recovery from user’s errors
recovery from process and instance failure
Performance Turning
get Statistic report from you database
turning processes
Job Placement Available!