they need to hold another class to make enough money to develop the next web page... Tom Mercadante Oracle Certified Professional -----Original Message----- Sent: Tuesday, July 31, 2001 11:16 AM To: Multiple recipients of list ORACLE-L Thats funny... -- Chris J. Guidry P.Eng. ATCO Electric, Metering Services Phone: (780) 420-4142 Fax: (780) 420-3854 Email: [EMAIL PROTECTED] > -----Original Message----- > From: Post, Ethan [SMTP:[EMAIL PROTECTED]] > Sent: Monday, July 30, 2001 05:20 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: (Fwd) Oracle8i Database Administration Boot camp > > No they can do it. Here is what one of thier students was able to > accomplish after a one day HTML class. > > http://www.telecommand.com/ > > - Ethan > > > -> -----Original Message----- > -> From: Garner, John (NESL-IT) > -> [mailto:[EMAIL PROTECTED]] > -> Sent: Monday, July 30, 2001 3:06 PM > -> To: Multiple recipients of list ORACLE-L > -> Subject: RE: (Fwd) Oracle8i Database Administration Boot camp > -> [small/Sacr > -> > -> > -> Its all sales!! > -> > -> The people that think they can do it quick will pay the > -> cash..... LA LA LA > -> > -> BAG OF SHITE I say!!! > -> > -> -----Original Message----- > -> Sent: 30 July 2001 20:57 > -> 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 > -> > -> ------- 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). > -> ************************************************************* > -> ******************************* > -> E mail Disclaimer > -> > -> You agree that you have read and understood this disclaimer > -> and you agree to be bound by its terms. > -> > -> The information contained in this e-mail and any files > -> transmitted with > -> it (if any) are confidential and intended for the addressee > -> only. If you have > -> received this e-mail in error please notify the originator > -> or telephone > -> 0191 210 2060 or e-mail [EMAIL PROTECTED] > -> > -> This e-mail and any attachments have been scanned for certain > -> viruses prior to sending but neither Northern Electric plc > -> nor any of the companies in the Northern Electric group of > -> companies from whom this e-mail originates shall be liable > -> for any losses as a result of any viruses being passed on. > -> > -> No warranty of any kind is given in respect of any > -> information contained in this e-mail and you should be aware > -> that that it might be incomplete, out of date or incorrect. > -> It is therefore essential that you verify all such > -> information with us before placing any reliance upon it. > -> > -> Northern Electric plc > -> Carliol House > -> Market Street > -> Newcastle-upon-Tyne > -> NE1 6NE > -> Registered in England and Wales: Number 2366942 > -> > -> > -> ************************************************************* > -> ******************************* > -> -- > -> Please see the official ORACLE-L FAQ: http://www.orafaq.com > -> -- > -> Author: Garner, John (NESL-IT) > -> 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). > -> > > -------------------------------------------------------------------------- > ---- > This e-mail is intended for the use of the addressee(s) only and may > contain privileged, confidential, or proprietary information that is > exempt from disclosure under law. If you have received this message in > error, please inform us promptly by reply e-mail, then delete the e-mail > and destroy any printed copy. Thank you. > > ========================================================================== > ==== > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Post, Ethan > 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: Guidry, Chris 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: Mercadante, Thomas F 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).
