Oracle DBA : Oracle DBA Sql Overview:
Basic Sql Statements like DML, DDL, TCL, DCL
Where Clause, Order by Clause, Operators, Sql Functions, Subqueries
Joins, Constraints, Views.
Slide 2 : Linux Overview:
Linux Installation
Linux Architecture, File System
Creating Files, Directories, Changing Permissions, Ownerships, CP + MV Commands
Wildcard Characters, Vi Editor Commands, Redirections Symbols, Search Commands
Soft Link, Hard Link, Process killing, Cpu Utilization.
Slide 3 : Oracle Database:
Installation:
Installing Oracle 9i Software
Installing Oracle 10g Software
Slide 4 : Architecture:
Architecture for Oracle 9i
Architecture for Oracle 10g
Explaining Oracle Database Server, Instance, Database
Defining Physical Structure, Logical Structure
Execution Plan of Sql Statement
Slide 5 : Database Creation:
Manual Database Creation
Database Startup/Shutdown Commands
Monitoring alertlog File, Trace Files, Checking Background Process
Data Dictionary Views and Dynamic Performance Views
Creating Spfile, Creating Pfile
Slide 6 : Managing Tablespaces and Datafiles:
Creating a Tablespace, Adding a Datafile, Resizing a Datafile, Renaming a Datafile
Putting Tablespades in Offline/Online/Read Only/Write/ReadWrite Modes
Locally Managed Tablespace and Dictionary Managed Tablespace
Slide 7 : Managing Undo Segments and Temp Tablespce:
Creating Undo Tablespace, Assigning Default Undo Tablespace and Undo Parameters
Creating/Assaining Default Temp Tablespace
Creating Password File
Slide 8 : User Management:
Creating User, Privileges, Profiles, Roles
Row Chaining and Row Migration
Slide 9 : Networking:
Shared Server Environment and Dedicated Server Envinorment
Creating/Managing Listener.ora File
Creating/Managing Tnsnames.ora File
Slide 10 : Managing Export and Imports:
Table Export/Import
Schema Export/Import
Database Export/Import
Slide 11 : Backup and Recovery:
Setting Datatbase in Archive Log Mode
Cold Backup and Hot Backup
User-managed Recovery
Completer Recovery and Incomplete Recovery (Normal Datafile Lost, System Datafile Lost, Controlfile Lost, Redolog File Lost, Arhive Log File Lost….)
Rman Backup and Recovery
Slide 12 : Tuning:
Making/Analyzing Statspack Report
Making/Analyzing Explain Plan
Slide 13 : 10g new Features:
Sysaux Tablespace + New Parameters + Deprecated Parameters + Streams_Pool_Size
Data Pump, AWR Report, ADDM Report, Renaming Tablespace,
Recyclebin, Flashback Recovery and Transportable Tablespace
Slide 14 : Database Cloning:
Patching:
Applying Patch Set From 9.2.0.4 To 9.2.0.8
Slide 15 : Upgradation:
Database Upgradation From 9.2.0.8 To 10.2.0.1
Installing Oracle 11g Software