Oracle Apps DBA Training in Bangalore

• Overview of Oracle DBA tasks
  
• Oracle as a flexible, complex & robust RDBMS
  
• He evolution of hardware and the relation to Oracle
  
• Different DBA job roles(VP of DBA, developer DBA, production DBA, database babysitter)
  
• The changing job role of the Oracle DBA
  
• Environment management (network, CPU, disk and RAM)
  
• Instance management (managing SGA regions)
  
• Oracle table and index management.

• Instance vs database
  
• Components of an instance
  
• Creating the OFA file structure (DBA, bdump, udump, pfile).  
  

• SGA vs PGA
  
• Background processes
  
• Interfaces with server and disk I/O subsystem. 
  

• Connecting and executing SQL
  
• Using the 'as sysdba' syntax
  
• Overview of SQL Plus DBA commands (startup, etc.) 
  

Creating New Database Users

• Using pre-spawned Oracle connections
  
• Auditing User activity
  
• Identifying System and Object Privileges
  
• Granting and Revoking Privileges
  
• Creating and Modifying Roles
  
• Displaying user security Information from the Data Dictionary 
  

• Describing the relationship between data files, tablespaces and table
  
• Understanding Oracle segments
  
• Creating Tablespaces – using the autoextend option
  
• Changing the Size of Tablespaces – alter database data file command
  
• Defining a TEMP tablespace
  
• Changing the default storage Settings for a tablespace
  
• Review of the storage parameters in DBA views (ASM, ASSM, pctfree, pctused and freelists).
  
• Monitoring Chained rows (fetch continued rows)
  
• Monitoring Insert and Update performance (pctused, APPEND) 
  

• Reason for reorgs – chained rows, imbalanced freelists
  
• Reorganizing Tables using Export and Import
  
• Using CTAS to reorganize data
  
• Index rebuilding
  
• Backup & Recovery overview (hot & cold Backups, RMAN, block change tracking) 
  

• Reason for reorgs – chained rows, imbalanced freelists
  
• Reorganizing Tables using Export and Import
  
• Using CTAS to reorganize data
  
• Index rebuilding
  
• Backup & Recovery overview (hot & cold Backups, RMAN, block change tracking) 
  

•  OS-level backups
  
•  Hardware-level backup & recovery
  
•  Block-level change tracking
  
•  Disk mirroring
  
• Backup & recovery and RAID level
  
• Oracle-level backups (exp, expdp & RMAN)
  
• Hot vs. Cold backups