module4-tablespaces_and_datafiles.htm; updated May 27, 2013; Figures shown in these notes are from Oracle document D11321GC11, Production 1.1 D34286, Oracle Database Concepts 11g Release 2 (11.2), and Oracle® Database Administrator’s Guide 11g Release 2 (11.2) E25494-03.
Module 4 – Tablespaces and Datafiles
These notes cover the creation and management of tablespaces and their associated datafiles. [...]
module3-database_startup.htm; updated May 21, 2013; Some figures shown in these notes are from the Oracle Database Concepts guide.
Module 3 – Database Startup
These notes cover the use of environment variables and Oracle naming conventions for files. You will:
· learn to create and understand initialization parameter files and several [...]
module2-oracle_server.htm; updated 5/20/2013. Some figures shown in these notes are from various Oracle documents including the Oracle® Database Concepts 11g Release 2 (11.2), Oracle® Enterprise Manager Concepts 11g Release 2 (11.2), Oracle® Universal Installer and OPatch User’s Guide 11g Release 2 (11.2) for Windows and UNIX
Module 2 – Oracle Server
File=module1-architecture.htm; updated 5/13/2013
Figures shown in these notes are from Oracle® Database Concepts 11g Release 2
Module 1 – Oracle Architecture
These notes introduce the Oracle server architecture. The architecture includes physical components, memory components, processes, and logical structures.
Primary Architecture Components
The figure shown above [...]
BUILDING THE PRODUCT_USER PROFILES
This describes the steps used to build user profiles with Oracle on LINUX. Running this script is required for SQL*Plus. It installs the SQL*Plus PRODUCT_USER_PROFILE tables. These tables allow SQL*Plus to disable commands by user.
The tables are used only by SQL*Plus and do not affect other client [...]
module18-tuning.htm; updated July 14, 2013
Module 18 – Database Tuning (and Other Performance Issues) Objectives Identify how poor system performance results from a poor database system design. Familiarize with how database tuning focuses on identifying and fixing underlying flaws. Familiarize with typical objects that can be tuned. TUNING APPLICATION DESIGN Effective Table Design Poor [...]
module17-network.htm; Updated July 14, 2013; Some figures in these notes are from the Oracle® Database Net Services Administrator’s Guide 11g Release 2 (11.2) E10836-07
Module 17 – Oracle Network Services
These notes cover Oracle network administration for an Internet environment.
· Familiarize with network environments, connect operations, exception operations, [...]
module16b-recovery_manager.htm; Updated July 10, 2013
Module 16b – Recovery Manager (RMAN)
· Learn basic concepts related the use of Recovery Manager (RMAN).
RMAN Features and Components
Recovery Manager (RMAN) is an Oracle Database client – it performs backup and recovery tasks and helps automate backup strategy administration.
module16-backup_recover.htm; Updated July 8, 2013; Reference: Oracle® Database Backup and Recovery User’s Guide 11g Release 2 (11.2) E10642-05
Module 16 – BACKUP and RECOVERY
· Learn basic concepts related to backup and recovery operations. · Perform normal backups (operating system) including cold backup (offline) and hot backup (online). · [...]
module15-syn_seq_view.htm; updated July 8, 2013; Some figures shown in these notes are from Oracle document D11321GC11. Ref: Oracle® Database Administrator’s Guide 11g Release 2 (11.2) E25494-03
Module 15 – Synonyms, Sequences and Views
Create and drop synonyms and public synonyms.
Generate values from sequences and use [...]