Oracle DBA 1 / 2 

Introduction, Basics & Overview of Oracle and Oracle DBA 

∙ Linux Setup on (Oracle VM) Virtual Machine 

o Setting up a VM (Virtual Machine) 

o Importing Linux Image into VM 

o Linux Commands – Example (PS, ls, top, df and many more) as required for DBA

∙ Installing Oracle Database Server on Linux VM 

o Installing Oracle 18c XE DB via rpm 

o Setting bash profiles 

o Working with Listeners, Tnsnames.ora & Listener.ora files 

∙ Understanding Oracle Database Architecture 

o Architectural Components 

o Background Processes 

o Memory structures like SGA, PGA, shared pool, large pool and many more

∙ Understanding Oracle Database Instance 

o PFILE, SPFILE and parameter changes 

o DB startup and shutdown modes 

o Alert.log, dictionary views and dynamic performance views 

∙ Understanding Database Storage Structures 

o Blocks 

o Extents 

o Segments 

∙ Table space Management 

o Introduction to Table space 

o Table space Creation 

o Managing Data files 

o Undo Table space 

o Temp Table space 

∙ Creating Database 

o Updating server files 

o Mapping Database Instance 

o Mapping Table spaces 

o Mapping users 

o Setting up privileges 

∙ Using Database 

o Table Creation 

o CRUD Operations 

o Table Management

∙ Administering User Security and Resources 

o Creating Users, Roles etc. 

o Assigning Roles 

o Managing Profiles 

∙ Managing Data Concurrency 

o Understanding Object and Row locking 

o Simulating locking Scenario, Detecting and Resolving it via SQL scripts

∙ Backup and Recovery 

o Types of backups: Hot and Cold 

o RMAN Backups 

o Putting DB in Archive log modes 

o Restoring DB from RMAN backup 

∙ Data Export / Import 

o SQL Loader 

o Export (and taking backups with export) 

o Export Data pump 

∙ Misc. Topics 

o db links 

o dbms_scheduler 

∙ SQL Tuning (Performance Enhancements) 

o Explain Plan 

o DBMS_STATS – Gathering statistics via Oracle supplied package DBMS_STATS o Creating Appropriate Indexes 

o Table Re-Organization 

∙ Partitioning 

o Types of Partitioning schemes 

o Table Partitioning, Table space Partitioning etc. 

o Understanding Effect of Partitioning 

o Listing Partitions 

∙ Instance Tuning & AWR Reports 

o Understanding AWR reports 

o AWR vs. ASH reports 

o Generating AWR reports 

o Reading AWR reports 

∙ Tuning Advisors 

o SQL query tuning advisor 

o Memory advisors: SGA, PGA, Database Buffer cache advisors 

o Automatic Database Diagnostics Monitor (ADDM) reports 

∙ Certification Preparation 

∙ Interview Prepare Sessions