+91-80999 02123201-710-8393

Oracle DBA Training

Oracle 10g/11g DBA Course Content
  • Architecture & Administration.
  • Oracle Architecture
  • Oracle Instance
  • SGA (Memory Structures)
  • BG Processes / Threads
  • Understanding Instance
Different Oracle Files
  • Data Files, Control Files,Redo log Files
  • Archived Redo log files, Temp Files
  • Password Files, Flashback log files
  • Parameter files, server parameter
  • Files, Trace files, alert log files ,Dump files,data pump files,flat files Change tracking files
Execution of SQL statements
  • Client to server communication
  • Dml & DDL execution
  • Parsing
  • Comitt and rollback
Different initialization Parameters Managing and Database Files
  • Managing data files and tablespaces
  • tablespace parameters
  • Dictionary vs locally managed
  • Tablespaces
  • Temperary tablespaces
  • Undo tablespaces
  • Big & small files
  • Parameters to be considered at tablespace creation time Fragmentation
  • Control files , multiflexing the control files
  • Redo log files, multiplexing the log files
Undo and temporary segments
  • Configuring automatic undo management
  • Configuring rollback segments
  • Creating temporary tablespaces
User management
  • Creating users, roles and profiles
  • Assigning default tablespaces
Starting up and shutting down
  • Different modes of startup & shutdown
  • Errors at startup and shutdown
Dedicated and shared server modes
  • Configuring shared server mode
  • Impact of shared server mode
Creating an Oracle database
  • Creating a database using DBCA
  • Creating a database manually
Database storage structures
  • Physical structures
  • Logical structure
  • Oracle block structure
Rollback and undo segments
  • Active rollback segments
  • Differed rollback segments
  • Concurrent users and no of rollback or undo segments
  • Common errors and solutions
Object management
  • Tables,views,synonyms,sequences,Dblinks …etc Back up and Recovery
  • Different database modes
  • No archive log mode
  • Archive log mode
  • No archive mode to archive log mode
Different types of backup
  • Logical backup (exp,imp,expdp,impdp)
  • Physical (hot/online and cold/offline)
  • Automating backups
Different recoveries
  • Differences between restore and recovery
  • Media recovery
  • Crash recovery
  • Complete vs. imcomplete recovery
  • Tablespace recovery
  • Datafile recovery
  • Database recovery
  • Tablespace point in time recovery
  • Block-level recovery
  • Thread recovery
  • Different other recovery scenarios
RMAN (recovery manager) backups
  • Featrures and configuration
  • Creating recovery catalog
  • Recovery eith/without recovery catalog
  • Ramn scripts
  • Recovery scenarios using RMAN
Logical backup
  • Exp,imp
  • Expdp,impdp
Flash back machanism
  • using DBMS_FLASHBACK
  • recovery at all level
  • database level
  • table level
  • row level
  • virtual recycle bin
recover data block corruption
  • using DBMS_REPAIR
  • block recoveries using RMAN
  • network management
  • concepts of neworking
  • understanding various configuration files
  • listener.ora, TNSnames.ora,sqlnet.ora
Server side configuration
  • Configuring listener using netca
  • Multiple listeners for load balancing
  • Stopping and starting listener
  • Configuring listener for MTS
Client side configuration
  • Configuring TNSnames.ora
  • Trouble shooting network related issues
  • Trouble shooting client side issues
  • Understanding database links
Enable tracing
  • Tracing listener.ora
  • Tracing TNSnames.ora
  • Tracing sqlnet.ora
  • Common errors and troubleshooting
  • Oracle performance Tuning
  • Introduction to tuning
  • Proactive and reactive tuning
Memory tuning
  • Tuning the database buffer cache
  • Tuning the shared pool
  • Tuning the redo log buffer
  • Different initialization parameters
  • Calculating different hit ratios
Avoid paging and swapping(SGA Sizing) SQL tuning
  • Querying V$SQLAREA and V$SQL
  • Caching a table in memory
  • Checking the indexing
  • Techniques in using different clauses
  • Tuning table joins
  • Using filtering conditions
Locks and latches
  • Object locks
  • Memory locks
Index management and tuning
  • Different types of indexes
  • Altering indexes
  • Rebuilding indexes
  • Analysing indexes
  • Index partitioning & ROWID
  • Using index hints
Oracle optimizer
  • Different optimizer modes (CBO and RBO)
  • Gathering optimizer statistics
  • DBMS_UTILITY and DBMS_STATS
  • Optimizer hints
Explain plan,TKPROF,SQL_TRACE
    Generating the execution plan into PLAN_TABLE
  • Digging into TKPROF output
  • Impact of generating SQL tracce
Tuning using stats pack
    Configuring the stats pack and gathering the statistics
  • Wait events
  • Top wait events and solutions
  • Top resource consuming SQLs
  • Top disk I/O tablespaces
Tuning the wait events and disk i/O
    Different types of wait events
  • Wait events tunin
  • g
  • Understanding different RAID levels
  • Distributing the data files
  • Using locally managed tablespaces
  • Avoid contention using partitioned tables
  • Has partition
  • Range partition
  • List partition
  • Composite partition
  • Moving partitions
  • Sorting in memory to reduce disk I/O
  • Killing the problem sessions
  • AWR,ADDM,ASH,DBMS_WORKLOAD_REPOSITARY base lines
Advanced Topics
    Standby datbaase / data guard
  • Features of data guard
  • Physical and logical standby databases
  • Active data guard
Database patching
    Opatch utility
  • Online patching
  • One off patches and patch sets
  • Oracle 11g new features
  • Automatic storeage management
  • Database auditing
  • Grid computing
  • Hidden parameters
  • Databse security
  • Database cloning
  • OEM management (jobs & events,isqlplus)
  • Address

    #3-5-839/6, 104, 1st Floor, LR Plaza, Beside Bharat Petrol Pump, Hyderguda,
    Hyderabad - 500 029

    Phone     : 040- 6464 5154
    Email      : info@careeronlinetrainings.com
    Website : www.careeronlinetrainings.com

    Skype ID : careeronlinetrainings

    Testimonials

    The course content was appropriate and useful. The online trainers were competent and useful. The best thing about the course was the young learner and learning Vs acquisition section.

    The thing that the course needs improvement is the format of the assignment

    Keerthi
    Hyderabad.

    I am Mushtak Shaik from Hyderabad. The course content was appropriate and useful. The online trainers were competent and useful.

    The thing that the course needs improvement is the format of the assignment


    Mushtak Shaik
    Hyderabad.