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: Boivin, Patrice J <BoivinP_at_mar.dfo-mpo.gc.ca>
Date: Tue, 31 Jul 2001 04:01:42 -0700
Message-ID: <F001.00359C84.20010731034055@fatcity.com>

This is a bit like book-selling: All you wanted to know about C++ and Oracle in 24 hours, including the Idiot's guide to the Mystery of Life and how to successfully avoid reincarnation with minimum effort. Avoid the mistake of having to live your life all over again! Just send us US$60 and believe in us and you will be saved.

Once you buy the book, or pay for the course, who cares if you don't come back? They have your money. The business is not based on return customers, they are aiming for people who want to make a quick career transition.

As for satisfaction guaranteed, I don't know what the customer-protection laws are like in the U.S. but reading some of the software disclosure legalese on some CD shrinkwrap, there don't appear to be any laws to protect consumers. It's good for the economy! We can't afford to slow down industry output...

To be fair, it's a competitive market for training schools. To stay afloat, they end up having to market the impossible.... like some software companies.

I always believed that vulnerable people tend to get taken advantage of because people only do what's right if the consequences are worse if they do what is wrong. It's not a will or character issue, it has more to do with entropy - to conserve energy, people tend to take the easy route. They run on autopilot most of the time, on habits.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

        -----Original Message-----
        From:   Garner, John (NESL-IT)
[SMTP:john.garner_at_northern-electric.co.uk]
        Sent:   Monday, July 30, 2001 7: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:                     <training_at_telecommand.com>
        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: PierceED_at_csus.edu 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). **************************************************************************** **************** 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 postmaster_at_northern-electric.co.uk.

        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: john.garner_at_northern-electric.co.uk 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: Boivin, Patrice J
  INET: BoivinP_at_mar.dfo-mpo.gc.ca

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 - 06:01:42 CDT

Original text of this message

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