- Configuration of the MS Windows operating systems in anticipation of a
database installation
- Server Class installation of the Oracle 11g R2 Enterprise Edition database
- Verification of a valid database installation
- Database administrator interface options, including the use of Enterprise
Manager, command-line SQL*Plus, and terminal console SSH
- Database deinstallation
- Online software patching
- Startup and shutdown of database services and related software components
- Super administrator authentication options
- 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.