RE: (Fwd) Oracle8i Database Administration Boot camp [small/Sacr
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:[EMAIL PROTECTED]] 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
RE: (Fwd) Oracle8i Database Administration Boot camp [small/Sacr
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
RE: (Fwd) Oracle8i Database Administration Boot camp [small/Sacr
They can market what they want, but as a participating member of this list, I wanted to let everyone know how far fetched it sounds. Hey if someone thinks they can handle it, by all means, but it would be sad day if someone went into it and thought it was a good quick get me up and found out they left more confused and probably lacking the desire to continue that path. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Tuesday, July 31, 2001 7:41 AM To: Multiple recipients of list ORACLE-L 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:[EMAIL PROTECTED]] 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
RE: (Fwd) Oracle8i Database Administration Boot camp [small/Sacr
I can only imagine. Perhaps they have them circled around a tree ;) Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Tuesday, July 31, 2001 9:55 AM To: Multiple recipients of list ORACLE-L 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
RE: (Fwd) Oracle8i Database Administration Boot camp [small/Sacr
Probably that they are doing the training from somebody's back yard on PC's that run on a generator powered by 1000 hamsters running on spinning wheel transformers. Lunch is self-service at your local McDonalds. :) In short they are really telling you that they are suckering $250 out of you - and not having to pay a thing out? Nice of them.. :) -Original Message- Thomas F Sent: Tuesday, July 31, 2001 02:55 To: Multiple recipients of list ORACLE-L [small/Sacr 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
RE: (Fwd) Oracle8i Database Administration Boot camp [small/Sacr
I'm supposed to know all this? Oh, oh. ;) Jim -Original Message- Sent: Monday, July 30, 2001 3: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 --- Forwarded message follows --- To: [EMAIL
RE: (Fwd) Oracle8i Database Administration Boot camp [small/Sacr
I have been doing Oracle admin for about 6 months now. I have literally spent a couple hundred hours RTFM and reading books. I feel that I have gotten much better in my understanding of Oracle, BUT, I would not consider myself an Oracle guru or anything close to it, which is obvious from the number of questions that I post to this list. I want to keep learning but that will take time and experience. I would not waste $250 on an 8 hour course. I cannot see how they can cram that much info into such a small session. Spending your money on some good Oracle books would be a wiser investment. Dave -Original Message- Sent: Tuesday, July 31, 2001 9:42 AM To: Multiple recipients of list ORACLE-L [small/Sacr I can only imagine. Perhaps they have them circled around a tree ;) Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Tuesday, July 31, 2001 9:55 AM To: Multiple recipients of list ORACLE-L 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
RE: (Fwd) Oracle8i Database Administration Boot camp [small/Sacr
Perhaps what they are doing is great, I just wanted to put in my thought that I think it is very far fetched and doesn't smell right. Perhaps it is completely useless perhaps it is great, I didn't want to go on and say anything more than that. Just didn't want to see anyone go into it thinking they will be set after it and will be amoung the greatest dba's in just 6.5 hours, to my knowledge, we are not in The Matrix. even a genius asks questions. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Tuesday, July 31, 2001 11:16 AM To: Multiple recipients of list ORACLE-L Probably that they are doing the training from somebody's back yard on PC's that run on a generator powered by 1000 hamsters running on spinning wheel transformers. Lunch is self-service at your local McDonalds. :) In short they are really telling you that they are suckering $250 out of you - and not having to pay a thing out? Nice of them.. :) -Original Message- Thomas F Sent: Tuesday, July 31, 2001 02:55 To: Multiple recipients of list ORACLE-L [small/Sacr 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
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 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
RE: (Fwd) Oracle8i Database Administration Boot camp [small/Sacr
A USB port connection wired straight to earphones and special eye wear. 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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce 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).
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
