Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: (Fwd) Oracle8i Database Administration Boot camp [small/Sacr

RE: (Fwd) Oracle8i Database Administration Boot camp [small/Sacr

From: Mercadante, Thomas F <NDATFM_at_labor.state.ny.us>
Date: Tue, 31 Jul 2001 06:15:58 -0700
Message-ID: <F001.00359E70.20010731055523@fatcity.com>

Chris,

Come-on! Never heard the phrase "There's a sucker born every minute - and two to take'em"?
The good news is that it "only" costs $250. You get what you pay for.

PS. "they have no overheads" - what does THAT mean?

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
Sent: Monday, July 30, 2001 4:57 PM
To: Multiple recipients of list ORACLE-L [small/Sacr

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

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.


...

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: ListGuru_at_fatcity.com (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: cspence_at_FuelSpot.com
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: ListGuru_at_fatcity.com (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: Mercadante, Thomas F
  INET: NDATFM_at_labor.state.ny.us
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: ListGuru_at_fatcity.com (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). Received on Tue Jul 31 2001 - 08:15:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US