Call: 080-42275527 / +91-9916056387

Architecture and configuration

 

1-1: OVERVIEW OF ORACLE DBA TASKS

  • Oracle as a flexible, complex & robust RDBMS
  • The 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

 

1-2: INSTANCE ARCHITECTURE

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

 

1-3: ORACLE INSTANCE INTERNALS

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

 

1-4: USING SQL*PLUS FOR DBA MANAGEMENT

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

 

1-5: CONTROL FILES, UNDO AND REDO MANAGEMENT

  • Explaining the use of control files
  • Listing the Contents of the control File
  • File locations for control Files
  • Obtaining Control File Information
  • Listing control file contents
  • Displaying and Creating Undo segments
  • Altering Undo Segments
  • Determining the Number and Size of Undo segments
  • Understanding flashback technology
  • Troubleshooting Undo – snapshot too old
  • Redo log concepts for recovery
  • Online redo log (log_buffer) online redo logs and archived redo logs
  • Oracle ARCH and LGWR background processes
  • Redo log dictionary queries
  • Redo log switch frequency and performance
  • Multiplexing the Online Redo Log Files
  • Archiving the Oracle Redo Logs
  • Recovery using the redo log files

 

1-6: USER AND PRIVILEGE MANAGEMENT

  • The three security methods (VPD, Grant security/role-based security, grant execute)
  • 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
Scroll Up