A sample text widget

Etiam pulvinar consectetur dolor sed malesuada. Ut convallis euismod dolor nec pretium. Nunc ut tristique massa.

Nam sodales mi vitae dolor ullamcorper et vulputate enim accumsan. Morbi orci magna, tincidunt vitae molestie nec, molestie at mi. Nulla nulla lorem, suscipit in posuere in, interdum non magna.

Module 4 – Tablespaces and Datafiles

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

 Objectives

 These notes cover the creation and management of tablespaces and their associated datafiles. [...]

Module 3 – Database Startup

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

 

Objectives

 

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 [...]

Module 2 – Oracle Server

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

 

Objectives

[...]

Module 1 – Oracle Architecture

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

 

Objectives

 

These notes introduce the Oracle server architecture. The architecture includes physical components, memory components, processes, and logical structures.

 

Primary Architecture Components

 

<”http://www.siue.edu/~dbock/cmis565/module1-architecture_files/image001.png”>

 

 

The figure shown above [...]

BUILDING THE PRODUCT_USER PROFILES

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 [...]

Module 18 – Database Tuning

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 [...]

Module 17 – Oracle Network Services

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

Objectives

 

These notes cover Oracle network administration for an Internet environment.

· Familiarize with network environments, connect operations, exception operations, [...]

Module 16b – Recovery Manager (RMAN)

module16b-recovery_manager.htm; Updated July 10, 2013

Module 16b – Recovery Manager (RMAN)

Objectives

· Learn basic concepts related the use of Recovery Manager (RMAN).

RMAN Features and Components

RMAN Components

 

Recovery Manager (RMAN) is an Oracle Database client – it performs backup and recovery tasks and helps automate backup strategy administration.

[...]

Module 16 – BACKUP and RECOVERY

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

Objectives

· Learn basic concepts related to backup and recovery operations. · Perform normal backups (operating system) including cold backup (offline) and hot backup (online). · [...]

Module 15 – Synonyms, Sequences and Views

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

 

Objectives

 

Create and drop synonyms and public synonyms.

Create sequences.

Generate values from sequences and use [...]