Oracle 11g DBA

INTRODUCTION TO ORACLE DBA What is DBA ? Why a Company needs a DBA? Roles & Responsibilities of DBA Oracle Architecture DATABASE CREATION Different Startup Modes Different Shutdown Modes Types of Database Creation Manual Method of Creation TABLESPACE MANAGEMENT Introduction to Table space Types of Table space(BIG & SMALL) STORAGE PARAMETERS What are segments? What are extents? Storage Parameters(Initial, Next, Min Extents, Xtents, Pctincrease) USER MANAGEMENT Who are Database Users? Why to create a User? Creation of Users Allocating table space Quotas to Users Levels of Authentication UNDO MANAGEMENT What is Undo? Why Undo required? Pending offline status Brief idea about Rollback segments Flashback Features SPFILE & OMF What is spfile? Difference between spfile and pfile NETWORKING IN ORACLE Introduction to Oracle Networking Network default location Editing Network file AVAILABILITY Introduction to Data Guard Types of Standby databases 11g New features in Data Guard RMAN Cloning Automatic Storage Management(ASM) SQL-LOADER Introduction to SQL Loader Types of files Control file AUDITING What is auditing? Why auditing performed? Types of Auditing Levels of Auditing FLASHBACK FEATURES Flashback Database Flashback Archive(11g)