|
Provided by: Affinity IT Training, LLC Oracle 9i DBA Fundamentals I |
 |
Training
Provided by Affinity IT Training, LLC
This class will develop the fundamental skills necessary to be an Oracle DBA.
Students will design and create a server using the Optimal Flexible Architecture
(OFA), configure logical and physical structures, set up database and user
security, add and administer users, and monitor and tune main server areas. Each
student will create a toolkit of administration scripts for database management
and tuning by the end of this class. This class will also address issues for
DBAs having to support Oracle8i and Oracle9i databases.
Audience:Database administrators, application developers, and system administrators.
|
|
||||||||||
Oracle 9i DBA Fundamentals I
Objectives
- Understand Oracle 9i internals sufficiently to perform basic administrative functions
- Understand how to perform basic administrative functions such as startup, shutdown, backups, restores, and verification
- Understand how to perform basic administrative functions such as database and account creation
- Be familiar with Oracle 9i security and permissions
- Understand Space, Segment, and Tablespace Management
- Understand Indexing
Outline
Oracle9i Server Architecture Review
Responsibilities of a DBA
Understanding the Oracle9i Server Architecture
Responsibilities of a DBA
Managing Different Types of Databases
What is an Oracle Server?
Oracle Versioning
Server Architectural Overview
Operating System Environment
Important Subdirectories in ORACLE_HOME
Oracle Product Subdirectories
Oracle Instance Components
Database Files
Control Files
Redo Log Files
Oracle Block Sizes
Blocks, Extents, and Segments
Different Types of Segments
Tablespaces
Logical Structural Design
System Change Numbers
Different Versions of Oracle
Oracle8.0 - The Object-Relational Release
Oracle8 Size Ceilings
Oracle8i - The Internet Release
Oracle9i Release 1- The eBusiness Database
Oracle9i - The Object Relational OLAP Database
Oracle Products and Architectures
Optimal Flexible Architecture
DBA Management Pack
Oracle Memory Structures and Processes
Oracle Instance Review
Database Buffer Cache
The LRU and Dirty Lists
Server Processes and the Buffer Cache
DBWR and the Buffer Cache
MTTR and Checkpoint Intervals
Checkpoints
Determining When Checkpoints Occur
Methods for Controlling Check Pointing
Minimal I/O Recovery
Defining Multiple DB Cache Buffer Pools
Defining the Database Buffer Pools
(Oracle8i style)
Database Buffer Pool Parameters
(Oracle9i style)
The Buffer Pool Parameter
Defining Storage for Buffer Pools
Calculating the Hit Ratio for Buffer Pools
Calculating Buffer Pool Sizes
Latch Contention
Caching Tables
Setup
- Access to Oracle 9i
- Accounts and databases for all Students and Instructor
Seminar Pre-Requisites
- Introduction To Oracle 9i
- An understanding of relational database concepts, SQL and PL/SQL programming skills are required.
- A solid understanding of Oracle schema is recommended.
Training Materials
- Course Workbook
1.0
About The Training Provider: Affinity IT Training, LLC
Affinity IT Training, LLC - .
We are a provider of hands-on, instructor-led IT training for the global business community including website development, databases, programming languages and more. Training includes: ASP, .NET, C#, C , DB2, AJAX, JavaScript, HTML/XHTML/XML, Unix, Linux, Perl, Python, Ruby On Rails, Oracle, Sybase, SQL Server, Project Management Training and customized Integrated Case Study.
