|
|
|
ORA02DBA-9i-01-SG
Oracle9i Database Administration - DBA I (5 days)
Description
This course provides a starting point for administration of the Oracle database. The first 2-day segment considers an in-depth discussion of the database architecture, including the Oracle instance, background processes, the SGA and memory structures, data files, tablespaces, extents, blocks and rows. Common administration tasks are also considered such as security, backup & recovery, physical storage of indexes and tables and many others. This course was formerly called “Oracle 9i Database Architecture & Administration – DBA I”.
Audience
Oracle database administrators.
Mandatory Prerequisites
• The Sideris course Introduction To Oracle 9i SQL
• The Sideris course Introduction To Oracle 9i PL/SQL Language
• The Sideris course Introduction To Oracle 9i Advanced SQL
Suggested Next Courses
• The Sideris course Oracle 9i Database Backup & Recovery - DBA II
• The Sideris course Oracle 9i Database Performance Tuning
Objectives
• Install, startup and shutdown an Oracle database
• Explain the internal architecture of data, memory and process structures
• Administer a security policy for the database
• Configure a basic backup & recovery strategy
• Control physical storage of tables and indexes
• Build efficient databases with clusters and bitmap indexes
Course Outline
THE ORACLE DATABASE ENVIRONMENT • APPLICATION ARCHITECTURES • THE ORACLE DATABASE • COMPONENTS OF A DATABASE • INSTANCE CONFIGURATIONS • ABOUT THE ADMINISTRATION TOOLS
MEMORY STRUCTURES WITHIN THE INSTANCE • PARAMETERS WHICH DETERMINE SGA SIZE
INSTANCE & USER PROCESSES • INSTANCE BACKGROUND PROCESSES • SQL EXECUTION PROCESSES
INSTALLATION & DATABASE CREATION • DATABASE ADMINISTRATOR AUTHENTICATION • PRE-INSTALLATION TASKS • POST-INSTALLATION TASKS
INSTANCE STARTUP & SHUTDOWN • DATABASE STARTUP • DATABASE SHUTDOWN • RESTRICTED SESSIONS • DATABASE FILES
DYNAMIC INSTANCE CONFIGURATION • DYNAMIC PARAMETER CHANGES • DETERMINING THE SCOPE OF CHANGES • VIEWING PARAMETER VALUES
USING LOCALLY-MANAGED TABLESPACES • ABOUT TABLESPACE MAINTENANCE • LOCALLY-MANAGED TABLESPACES • TEMPORARY SEGMENTS & TABLESPACES • THE OPTIMAL FLEXIBLE ARCHITECTURE
USING DICTIONARY-MANAGED TABLESPACES • DICTIONARY-MANAGED TABLESPACES • MIGRATING THE TABLESPACE MANAGEMENT METHOD
MANAGING DATA FILES • THE STORAGE HIERARCHY • EXPLORING THE PHYSICAL STORAGE HIERARCHY • MANAGING THE DATA FILES
MANAGING REDO LOGS
AUTOMATIC UNDO SPACE MANAGEMENT • CONFIGURING AUTOMATIC UNDO SPACE MANAGEMENT • TUNING AUTOMATIC UNDO SPACE MANAGEMENT
IMPLEMENTING ORACLE MANAGED FILES
MANAGING USERS • USER MANAGEMENT • ABOUT PRIVILEGES • RESOURCE LIMITS VIA PROFILES • PASSWORD MANAGEMENT VIA PROFILES
MANAGING PRIVILEGES VIA ROLES
UTILITIES, LOADING DATA • USING THE LOADER • UNDERSTANDING THE LOADER PROCESS • CONTROL FILE OPTIONS • DIRECT PATH LOADS
UTILITIES, EXPORTING & IMPORTING DATA
MANAGING INDEXES • INDEXES & INDEX SEGMENTS • ABOUT B-TREE INDEXES • ABOUT BITMAP INDEXES • INDEX DEFINITIONS WITHIN THE DATA DICTIONARY
MANAGING CLUSTERS & INDEXED ORGANIZED TABLES
GLOBALIZATION WITH NATIONAL LANGUAGE SUPPORT (NLS)
AUDITING DATABASE USAGE • AUDITING USERS & OBJECTS
SPECIFYING AUDITING ACTIONS
|
|
|
|
| After database installation and configuration, protect your data and achieve optimum performance with these additional skills. |
|
 |
|
|
|
|
|
|
