I would be curious how one can obtain to be "amoung the best" after a single
7.5 hour course which I assume has an 1 hour lunch when most training does
similar in about 80-180 hours.
There is some smart people in this world, and I found out I am not one of
them, but trying to tackle this list of objectives I just can't see possible
in 6.5 hours.
Understanding the Oracle Server Architecture
Responsibilities of a DBA
What is an Oracle 8.1 server?
Oracle8i JVM architecture
Operating system environment
Important subdirectories in ORACLE_HOME
Oracle instance components
Database files
Logical storage structures
Blocks, extents and segments
Different types of segments
Tablespaces
Logical structural design
Control files
Redo log files
System change numbers
Oracle architectures
Optimal flexible architecture
Oracle Memory Structures and Processes
Oracle instance review
Data block buffer cache
Redo log buffer cache
Shared pool area
Large pool area
Java pool size
Checkpoints
Determining when checkpoints occur
Program global areas
Background processes
Using the data dictionary
Base tables and static views in the data dictionary
Dynamic views in the data dictionary
ALL_ views
DBA_ views
USER views
Additional views
V$ views
GV$ views
Useful database data dictionary views
Creating an Oracle Instance and Database
Database utilities
New SQL*Plus features in Oracle 8i
The server manager tool
Server manager commands
Server manager set and show commands
The parameter file
Oracle installer
Setting up a parameter file
Important parameters for database creation
Starting an Oracle server
The STARTUP command
Shutdown steps
SHUTDOWN command options
ALTER DATABASE command
Preparation for creating a database
Steps for creating a database
Setup for UNIX
Setup for NT
Removing Oracle servers
The CREATE DATABASE command
Creating a database script
What is created?
Preinstalled users
Preinstalled roles
After database creation
Troubleshooting database creation
Alert and trace files
Database limits
Working with data dictionary views
Dynamic versus static parameters
Managing tablespaces and datafiles
Logical and physical structures
Tablespaces
The SYSTEM tablespace
CREATE TABLESPACE command
CREATE TABLESPACE clauses
Creating a tablespace
Dictionary-managed space
Dictionary-managed tablespaces
Locally-managed space
Locally-managed tablespaces
Managed space for SYSTEM tablespace
ALTER TABLESPACE command
Temporary tablespaces
CREATE TEMPORARY TABLESPACE Command
Read-only tablespaces
Coalescing tablespaces
Using the ALTER TABLESPACE command
Taking tablespaces ONLINE and OFFLINE
Tablespace offline options
Renaming a data file
Adding more space to a database
Autoextending a data file
DROP TABLESPACE command
Data dictionary views
Oracle8i Tables and Indexes
Oracle8i size ceilings
Managing large tables with Oracle7
Oracle8i data storage
What is partitioning?
A partitioned table
Partition features
Advantages of partitioning
Creating a partitioned table
The partition key
Partition syntax
Accessing a partitioned table
Data dictionary views
Using MAXVALUE
Partitioning rules to follow
Partition naming rules
Partition extended table name syntax
Restrictions on partition extended name
Multi-column partition keys
Inserting into a multi-column partition key
Modifying partition key values
Setting physical attributes for partitions
Partition management
Oracle8 indexes
Index-organized tables
Temporary tables
Reverse key indexes
Managing Rollback and Temporary Segments
Database block
Block utilization parameters
Data dictionary views on storage structures
Rollback segments
Private versus public rollback segments
Typical layout for rollback segments
Space usage
Sizing rollback segments
The OPTIMAL parameter
CREATE ROLLBACK SEGMENT command
ALTER/DROP ROLLBACK SEGMENT command
Using the SET TRANSACTION command
Data dictionary views for rollback segments
Recommendations for rollback segments
Temporary segments
Tablespaces and temporary segments
Administration of control and redo log files
Control file contents
Working with control files
Multiplexing control files
Review of redo log files
Writing to redo log files
Log sequence numbers
Checkpoints
Checkpoint events
Adding and clearing online redo log files
Dropping online redo log files
Renaming online redo log files
ARCHIVE LOG LIST command
Data dictionary views for redo log files
"Walking on water and developing software from a specification are easy if
both are frozen."
Christopher R. Spence
Oracle DBA
Fuelspot
-----Original Message-----
Sent: Monday, July 30, 2001 2:56 PM
To: Multiple recipients of list ORACLE-L
fyi
------- Forwarded message follows -------
To: <[EMAIL PROTECTED]>
Date sent: Sat, 28 Jul 2001 17:45:32 -0700
Dear IT Professional,
The training division of Telecommand, Inc. is conducting a 1-Day rigorous
hands-on class on Oracle8i database administration. The training will take
place in the latest Sun Solaris 8 environment. You will be learning in a
ultra small class of 12 students. Ravi Verma who has over 12 years of
experience in Oracle database administration is teaching the course. At the
end of the day you will be among the very best in the field of Oracle 8i
Database administration.
Please sign up at http://www.telecommand.com/training/
Following are the details:
Date: Friday 09/07/2001 and Saturday 09/08/2001
Place: Computer Science Laboratory at the California State University,
Sacramento
Time: 9:30 AM to 5:00 PM
Class Size: 12
Fee: $250.0 We can keep the cost low because we have no overheads!!!
Telecommand, Inc. is CMAS certified for classroom training.
Instructor: Ravi Verma
Sign up: http://www.telecommand.com/training/
Course detail:
This course will teach students the fundamental skills required to manage
Oracle databases. Students will learn database administration skills by
designing, setting up, configuring, and managing their own Oracle8i server.
By the end of the class, each student will have gone through the main tasks
necessary to manage Oracle8i databases. New Oracle8i features such as the
Oracle8i JVM, locally-managed tablespaces, partitioned tables, global and
local indexes, index-organized tables, function-based indexes,
object-relational features, the large pool and the Java pool will be
covered.
Audience: Database administrators, application developers, and system
administrators.
Prerequisites: Oracle for Application Developers. Previous working
experience with Oracle is recommended. A solid understanding of SQL and
PL/SQL is required. A base understanding of the operating system used for
class (UNIX or NT) is needed as well.
******
...
------- End of forwarded message -------
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Eric D. Pierce
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from). You may also send the HELP
command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Christopher Spence
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).