unfortunately i'm busy taking my kids fishing in our kayaks on that day, and won't be able to attend and report back on the experience. sooooooooooooooo sad. :) regards, ep > From: Christopher Spence <[EMAIL PROTECTED]> > Date: Mon, 30 Jul 2001 15:55:58 -0400 > Subject: RE: (Fwd) Oracle8i Database Administration Boot camp >[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 -- 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).
