Price: $3500
Duration: 5 Days
Audience:
Level:
Technology: .NET
Delivery Method:
Software Assurance Value:
Microsoft CPE:
The overall objective of this course is to allow the student to gain the skills necessary for day-today administration of an Oracle database. This course is the starting point for Oracle database administrators and also sets the foundation for advanced administrator training and certification
Specific subject areas to be explored and objectives to be reached are:
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 primary target audience for this course 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 information useful. This course is also recommended for technical consultants, support engineers, project managers and other technical management and support personnel.
ENTERPRISE EDITION INSTALLATION
IDENTIFY SYSTEM REQUIREMENTS
THE OPTIMAL FLEXIBLE ARCHITECTURE (OFA)
ORACLE_BASE
ORACLE_HOME
CONFIGURE THE INSTALLATION ENVIRONMENT
ENTERPRISE EDITION INSTALLATION
DBCA
THE ADMINISTRATOR INTERFACE
ENTERPRISE MANAGER TOUR
USING EM SQL WORKSHEET
DUTIES OF A DATABASE ADMINISTRATOR
EXPLORING THE ORACLE DATABASE ARCHITECTURE: GENERAL
THE ORACLE ENTERPRISE ARCHITECTURE
EXPLORING THE ORACLE DATABASE ARCHITECTURE: INSTANCE MEMORY
WHAT IS AN ORACLE DATABASE INSTANCE?
MORE ABOUT THE SYSTEM GLOBAL AREA (SGA)
ABOUT THE PGA
MANAGING MEMORY
EXPLORING THE ORACLE DATABASE ARCHITECTURE: INSTANCE PROCESSES
INSTANCE BACKGROUND PROCESSES
SQL EXECUTION PROCESSES
CREATING AN ORACLE DATABASE
CREATE A NEW DATABASE
CONFIGURE AN EXISTING DATABASE
DROP A DATABASE
MANAGE DBCA TEMPLATES
MANUALLY CREATE A DATABASE
MANAGING THE DATABASE INSTANCE
CONFIGURING A LINUX ENVIRONMENT
STARTING & STOPPING DATABASE CONTROL
STARTING & STOPPING THE DATABASE LISTENER
STARTING & STOPPING THE DATABASE INSTANCE
MORE ABOUT THE DATABASE FILES
MANAGE DATABASE STORAGE STRUCTURES: TABLESPACES
ABOUT TABLESPACES
TABLESPACE MANAGEMENT
DROP TABLESPACE
ALTER TABLESPACE
MANAGE DATABASE STORAGE STRUCTURES: ADVANCED TABLESPACES
MORE ABOUT TEMPORARY TABLESPACES
ABOUT TEMPORARY TABLESPACE GROUPS
MORE ABOUT PERMANENT TABLESPACES
MORE ABOUT BIGFILE TABLESPACES
MORE ABOUT THE SYSAUX TABLESPACE
MANAGE DATABASE STORAGE STRUCTURES
DATA FILES & TEMP FILES
MANAGING DATA FILES
MANAGING TEMP FILES
ENABLE ORACLE-MANAGED FILES (OMF)
MANAGING UNDO DATA
ABOUT UNDO SPACE MANAGEMENT
CONFIGURE AUTOMATIC UNDO MANAGEMENT
UNDO_MANAGEMENT
UNDO_TABLESPACE
UNDO_RETENTION
GUARANTEE UNDO RETENTION
MONITOR UNDO SPACE
USE THE UNDO ADVISOR
NETWORK ENVIRONMENT: ORACLE SHARED SERVERS
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
SECURITY: IMPLEMENTING DATABASE SECURITY
DATABASE SYSTEM PRIVILEGES
DATABASE OBJECT PRIVILEGES
ADMINISTRATOR AUDITING OF DATABASE ACTIVITY
ENHANCED DEFAULT SECURITY SETTINGS
SECURITY: ADMINISTERING USER SECURITY
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
MOVING DATA: SQL LOADER
LOADER CONCEPTS
CONTROL FILE OPTIONS
LOAD METHODS
USING THE EM INTERFACE
MOVING DATA: EXPORT & IMPORT
MANAGE DIRECTORY OBJECTS
ABOUT THE DATA PUMP ARCHITECTURE
DATA PUMP EXPORT
DATA PUMP IMPORT
DATA PUMP DATA DICTIONARY VIEWS
DATABASE MAINTENANCE & PERFORMANCE MANAGEMENT
THE MANAGEMENT & ADVISORY FRAMEWORK
MANAGE THE AUTOMATIC WORKLOAD REPOSITORY
AUTOMATIC DATABASE DIAGNOSTIC MONITOR
USE METRICS & ALERT THRESHOLDS
AUTOMATIC MAINTENANCE TASKS
MANAGING CONCURRENCY & LOCKS
ABOUT LATCHES & LOCKS
MANAGE & MONITOR LATCHES
MANAGE & MONITOR LOCKS
V$LOCK
V$LOCKED_OBJECT
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
The following courses are mandatory prerequisites for this course:
ora11g001, Oracle Database 11G: SQL Fundamentals � Complete Library
ora11g101, Oracle Database 11G: Program with PL/SQL � Complete Library