oracle 11g administration - essentials

By attending Oracle 11g Administration - Essentials workshop, Participants will learn:

  • Software installation and the creation of new databases
  • An in-depth exploration of the database architecture, including memory, process and data structures, and the management of those structures
  • Management of database files
  • Specialized facilities intended to maximize performance of enterprise-scale transactional applications, such as the shared SQL and PL/SQL cache, the result cache, the database buffer cache, and other similar components
  • Management of security policies and procedures, including administration of user accounts, roles, privileges and profiles
  • Utilization of advanced self-tuning and self-management capabilities, including the use of Oracle-Managed Files, database Advisors and other components of the Management Framework
  • Performance monitoring, problem troubleshooting, and resolving lock and conflict issues.
  • Using the Oracle Enterprise Manager and SQL interfaces for administration tasks
  • Control over database support services, including the Database Control, Oracle Net and others
  • A primer on backup and recovery structures and strategies
  • Operating system-specific considerations for various platforms, especially Linux and MS Windows Server

The Oracle 11g Administration - Essentials Training is designed to give Participants a firm foundation in basic administration of Oracle Database 11g. In this class, they learn to install and maintain Oracle Database 11g. They will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. They learn to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques.

Participants attending Oracle 11g Administration - Essentials class should have familiarity with system administration and administration of other non-Oracle databases, and Oracle 11g Administration is helpful though not mandatory. In addition they should have knowledge of:

  • Sql Fundamentals
  • PL/SQL

The primary target audience for this class is Oracle database administrators. Oracle web server and application server administrators, as well as others who must manage an embedded repository database using Oracle database technology will also find this course useful. This course is also recommended for technical consultants, support engineers, project managers and other technical management and support personnel.

COURSE AGENDA

  • Instance Background Processes
  • SQL Execution Processes
  • Create a New Database
  • Configure An Existing Database
  • Drop a Database
  • Manage DBCA Templates
  • Manually Create a Database
  • What Is An Oracle Database Instance?
  • More About the System Global Area (sga)
  • About the PGA
  • Managing Memory
  • Enterprise Manager Tour
  • Using EM SQL Worksheet
  • Duties of a Database Administrator
  • Exploring the Oracle Database Architecture: General
  • Identify System Requirements
  • The Optimal Flexible Architecture (OFA)
  • Oracle_base
  • Oracle_home
  • Configure the Installation Environment
  • Enterprise Edition Installation
  • DBCA
  • Configuring a Linux Environment
  • Starting & Stopping Database Control
  • Starting & Stopping the Database Listener
  • Starting & Stopping the Database Instance
  • More About the Database Files
  • About Tablespaces
  • Tablespace Management
  • Drop Tablespace
  • Alter Tablespace
  • More About Temporary Tablespaces
  • About Temporary Tablespace Groups
  • More About Permanent Tablespaces
  • More About Bigfile Tablespaces
  • More About the Sysaux Tablespace
  • Data Files & Temp Files
  • Managing Data Files
  • Managing Temp Files
  • Enable Oracle-managed Files (OMF)
  • About Undo Space Management
  • Configure Automatic Undo Management
  • Undo_management
  • Undo_tablespace
  • Undo_retention
  • Guarantee Undo Retention
  • Monitor Undo Space
  • Use the Undo Advisor
  • Shared Servers Architecture
  • Configure Shared Servers
  • Monitor Shared Servers
  • V$shared_server
  • V$shared_server_monitor
  • V$session
  • V$circuit
  • V$dispatcher & V$dispatcher_config
  • V$queue
  • Database System Privileges
  • Database Object Privileges
  • Administrator Auditing of Database Activity
  • Enhanced Default Security Settings
  • Create & Manage Database Accounts
  • Grant & Revoke Database Privileges
  • Resource Limits Via Profiles
  • Alter Profile
  • Drop Profile
  • Password Management Via Profiles
  • About Role-based Security
  • With Admin Option
  • Alter User...default Role
  • Set Role
  • Enhanced Default Security Settings
  • Loader Concepts
  • Control File Options
  • Load Methods
  • Using the EM Interface
  • Manage Directory Objects
  • About the Data Pump Architecture
  • Data Pump Export
  • Data Pump Import
  • Data Pump Data Dictionary Views
  • Using the EM Interface
  • The Management & Advisory Framework
  • Manage the Automatic Workload Repository
  • Automatic Database Diagnostic Monitor
  • Use Metrics & Alert Thresholds
  • Automatic Maintenance Tasks
  • About Latches & Locks
  • Manage & Monitor Latches
  • Manage & Monitor Locks
  • V$lock
  • V$locked_object
  • V$session
  • V$session_wait
  • Dba_blockers & Dba_waiters
  • Dba_dml_locks & Dba_ddl_locks
  • Dml_locks
  • Backup & Recovery Concepts & Configuration
  • About Database Backup & Recovery Structures
  • Managing Redo Data
  • Managing Archival Data
  • Automatic Crash Recovery
  • Creating a Basic Backup Strategy