Oracle DBA

  • Introduction
    • Identify the oracle product
    • Describe the basic concept of a relational database
  • Installing oracle database 10g software
    • System requirements
    • Use Oracle Optimal Flexible Architecture (OFA)
    • Install software with the Oracle Universal Installer
  • Create an oracle database
    • Oracle Database Architecture
    • Oracle instance architecture
    • Use the Database Creation Assistant
  • Controlling the database
    • Manually configure the Oracle 10g EM dbconsole
    • Start and stop the agent
    • Start and stop the enterprise manager database console
    • Start and stop the listener
    • Startup and shutdown the database
  • Storage Structures
    • Defining the tablespaces and data files
    • Create tablespaces
    • Manage tablespaces
    • Obtain tablespace information
    • Create and manage tablespace using oracle enterprises manager
  • Administering users
    • Create and manage database user accounts
    • Create and manage roles
    • Grant and revoke privileges
  • Oracle Database Security --- Only Theory
    • Apply the principal of least privilege
    • Manage default user accounts
    • Implement standard password security features
  • Oracle Net Services
    • Understand Oracle Net concepts
    • Use Oracle Net Manager to create and configure listeners
    • Use the Oracle Net Manager to configure client and middle-tier connection
    • Use TNSPING to test Oracle Net connectivity
  • Performance Monitoring
    • Gather optimizer statistics
    • View performance metrics
  • Monitoring and Managing Memory
    • Oracle Memory Structures
    • Automatic PGA Memory Management
    • Using the Memory Advisor
    • Using Automatic Shared Memory Management to avoid long running query issues

QUICK ENQUIRY