RE: Simple favor from the guru's
Well, thats about as clear as you can get. Stephen, I guess that should give you enough ammo to shoot your co-worker with :-) -Original Message- Sent: 16 August 2002 03:18 To: Multiple recipients of list ORACLE-L Lord knows I am one of the first to disparage the validity of OCP as a measure of what a DBA should/does really know... however, this is the reply I received from a friend who is an instructor at Oracle University. What they have learned, is NOT what they have been taught. The information this student provided is wrong and would be wrong an all versions of the ocp exam. I have provided notes from chapter one of the Oracle 9i DBA Fundamentals I course notes. Chapter 1 Page 3 Oracle Instance: An Oracle Instance is the combination of the background processes and memory structures. The instance must be started to access the data in the database. Every time an instance is started, a System Global Area (SGA) is allocated and Oracle background processes are started,. Background processes perform functions on behalf on invoking processes. They consolidate functions that would otherwise be handled by multiple Oracle programs running for each users. The background processes perform input/output and monitor other oracle processes to provide increased parallelism for better performance and reliability. Chapter 1 Page 3 Oracle database: An Oracle Database consists of operating system files, also known as database files. They provide the actual physical storage for database information. The database files are used to ensure that the data is kept consistent and can be recovered in the event of a failure of the instance. Chapter 1 Page 9 An Oracle database consist of three file types. Data files containing the actual data in the database, redo logs containing a record of changes made to the database to enable recovery of the data in case of instance failure, and control files containing information necessary to maintain and verify data integrity. Immediately after the definition of a database above is the heading Other Key File Structures, beneath this heading it says The oracle server also uses other files that are NOT part of the database: - The parameter file that defines the characteristics of an Oracle Instance For example it contains parameters that size some of the memory structures of the SGA. - The password file that authenticates users privileged to startup and shutdown an oracle instance (remotely) - Archived Redo log files are offline copies of the redo log files that may be necessary to recover from media failures. Hope this helps clear up any confusion, --- Karniotis, Stephen [EMAIL PROTECTED] wrote: Everyone: I am looking to all of my esteemed peers and gurus to clarify something that I know is blatantly wrong. Here is the scenario. I have a co-worker that is preparing for the DBA OCP debacle. They have completed a significant portion of the training and are preparing to take the first set of exams. To see what they have learned, I asked them to define what comprises an Oracle Instance and what comprises an Oracle database. Here are the responses I got: An Oracle Instance The database instance contains storage areas that allow users to use the database, data dictionary, redo log buffers and various processes that help to maintain, tune and run the database An Oracle Database The Database files consist of the parameter file or init.ora file, the physical data files, the control file and the redo log files and archived log files if the database is run in archive log mode Now, we all know that an Oracle instance comprises the background processes, the memory processes, memory storage areas, the and INIT.ORA parameters whereas the database comprises the physical files, data dictionary, users, objects, etc. The problem I have is the education is being supplied by our favorite vendor, Oracle. Did I go on vacation too long or is Oracle professing incorrect information in the OCP. Can one of the people that has taken the exam the classes look this up in the manuals for me? This proves my theory of refusing to take this exam unless hogwhipped and tied down (Rachel, sit down please and thanks for volunteering). If bad information is being given, then what's the use of the exam? Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official
RE: Simple favor from the guru's
Lee: Already did. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Friday, August 16, 2002 5:04 AM To: Multiple recipients of list ORACLE-L Subject:RE: Simple favor from the guru's Well, thats about as clear as you can get. Stephen, I guess that should give you enough ammo to shoot your co-worker with :-) -Original Message- Sent: 16 August 2002 03:18 To: Multiple recipients of list ORACLE-L Lord knows I am one of the first to disparage the validity of OCP as a measure of what a DBA should/does really know... however, this is the reply I received from a friend who is an instructor at Oracle University. What they have learned, is NOT what they have been taught. The information this student provided is wrong and would be wrong an all versions of the ocp exam. I have provided notes from chapter one of the Oracle 9i DBA Fundamentals I course notes. Chapter 1 Page 3 Oracle Instance: An Oracle Instance is the combination of the background processes and memory structures. The instance must be started to access the data in the database. Every time an instance is started, a System Global Area (SGA) is allocated and Oracle background processes are started,. Background processes perform functions on behalf on invoking processes. They consolidate functions that would otherwise be handled by multiple Oracle programs running for each users. The background processes perform input/output and monitor other oracle processes to provide increased parallelism for better performance and reliability. Chapter 1 Page 3 Oracle database: An Oracle Database consists of operating system files, also known as database files. They provide the actual physical storage for database information. The database files are used to ensure that the data is kept consistent and can be recovered in the event of a failure of the instance. Chapter 1 Page 9 An Oracle database consist of three file types. Data files containing the actual data in the database, redo logs containing a record of changes made to the database to enable recovery of the data in case of instance failure, and control files containing information necessary to maintain and verify data integrity. Immediately after the definition of a database above is the heading Other Key File Structures, beneath this heading it says The oracle server also uses other files that are NOT part of the database: - The parameter file that defines the characteristics of an Oracle Instance For example it contains parameters that size some of the memory structures of the SGA. - The password file that authenticates users privileged to startup and shutdown an oracle instance (remotely) - Archived Redo log files are offline copies of the redo log files that may be necessary to recover from media failures. Hope this helps clear up any confusion, --- Karniotis, Stephen [EMAIL PROTECTED] wrote: Everyone: I am looking to all of my esteemed peers and gurus to clarify something that I know is blatantly wrong. Here is the scenario. I have a co-worker that is preparing for the DBA OCP debacle. They have completed a significant portion of the training and are preparing to take the first set of exams. To see what they have learned, I asked them to define what comprises an Oracle Instance and what comprises an Oracle database. Here are the responses I got: An Oracle Instance The database instance contains storage areas that allow users to use the database, data dictionary, redo log buffers and various processes that help to maintain, tune and run the database An Oracle Database The Database files consist of the parameter file or init.ora file, the physical data files, the control file and the redo log files and archived log files if the database is run in archive log mode Now, we all know that an Oracle instance comprises the background processes, the memory processes, memory storage areas, the and INIT.ORA parameters whereas the database comprises the physical files, data dictionary, users, objects, etc. The problem I have is the education is being supplied by our favorite vendor, Oracle. Did I go on vacation too long or is Oracle professing incorrect information in the OCP. Can one of the people that has taken the exam the classes look this up in the manuals for me? This proves my theory of refusing to take this exam unless hogwhipped and tied down (Rachel, sit down please and thanks for volunteering). If bad information is being given, then what's the use of the exam? Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com
Re: Simple favor from the guru's
Maybe those guys were attending the classes at Oracle but were enjoying the break from work [being at some other place, but not an Oracle Education Centre]. Hemant At 11:18 AM 15-08-02 -0800, you wrote: Everyone: I am looking to all of my esteemed peers and gurus to clarify something that I know is blatantly wrong. Here is the scenario. I have a co-worker that is preparing for the DBA OCP debacle. They have completed a significant portion of the training and are preparing to take the first set of exams. To see what they have learned, I asked them to define what comprises an Oracle Instance and what comprises an Oracle database. Here are the responses I got: An Oracle Instance The database instance contains storage areas that allow users to use the database, data dictionary, redo log buffers and various processes that help to maintain, tune and run the database An Oracle Database The Database files consist of the parameter file or init.ora file, the physical data files, the control file and the redo log files and archived log files if the database is run in archive log mode Now, we all know that an Oracle instance comprises the background processes, the memory processes, memory storage areas, the and INIT.ORA parameters whereas the database comprises the physical files, data dictionary, users, objects, etc. The problem I have is the education is being supplied by our favorite vendor, Oracle. Did I go on vacation too long or is Oracle professing incorrect information in the OCP. Can one of the people that has taken the exam the classes look this up in the manuals for me? This proves my theory of refusing to take this exam unless hogwhipped and tied down (Rachel, sit down please and thanks for volunteering). If bad information is being given, then what's the use of the exam? Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karniotis, Stephen 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). Hemant K Chitale Now using Eudora Email. Try it ! My home page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale 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: Simple favor from the guru's
Immediately after the definition of a database above is the heading Other Key File Structures, beneath this heading it says The oracle server also uses other files that are NOT part of the database: - The parameter file that defines the characteristics of an Oracle Instance For example it contains parameters that size some of the memory structures of the SGA. - The password file that authenticates users privileged to startup and shutdown an oracle instance (remotely) - Archived Redo log files are offline copies of the redo log files that may be necessary to recover from media failures. Just as an aside, it was mentioned in the New Features class that the spfile is/is becoming a database file. I'm not really clear on what exactly it is considered to be now. Maybe someone else can illuminate. PAX, John P Weatherman Database Administrator Replacements Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman 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: Simple favor from the guru's
Title: RE: Simple favor from the guru's Stephen, 1. Pay for bad training. 2. Pay for test. 3. Fail test and pay for more training. 4. Pay for second test 5. etc. Probably not true but would make Oracle more money. As an instructor of things as diverse as aircraft maintenance to databases, I bet it is the student. That's why we give mid-term tests so that we can correct misconceptions and errors. The Oracle training I took about 2 years ago didn't include any tests. Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: Karniotis, Stephen [SMTP:[EMAIL PROTECTED]] Everyone: I am looking to all of my esteemed peers and gurus to clarify something that I know is blatantly wrong. Here is the scenario. I have a co-worker that is preparing for the DBA OCP debacle. They have completed a significant portion of the training and are preparing to take the first set of exams. To see what they have learned, I asked them to define what comprises an Oracle Instance and what comprises an Oracle database. Here are the responses I got: An Oracle Instance The database instance contains storage areas that allow users to use the database, data dictionary, redo log buffers and various processes that help to maintain, tune and run the database An Oracle Database The Database files consist of the parameter file or init.ora file, the physical data files, the control file and the redo log files and archived log files if the database is run in archive log mode Now, we all know that an Oracle instance comprises the background processes, the memory processes, memory storage areas, the and INIT.ORA parameters whereas the database comprises the physical files, data dictionary, users, objects, etc. The problem I have is the education is being supplied by our favorite vendor, Oracle. Did I go on vacation too long or is Oracle professing incorrect information in the OCP. Can one of the people that has taken the exam the classes look this up in the manuals for me? This proves my theory of refusing to take this exam unless hogwhipped and tied down (Rachel, sit down please and thanks for volunteering). If bad information is being given, then what's the use of the exam? Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web: www.compuware.com
Re: Simple favor from the guru's
Dang, and here I was going to the supply closet for the whips and ropes. you never let me have ANY fun! :) and (putting on English teacher hat) the correct idiomatic expression is hogtied and whipped (gotta get *some* fun out of this) I know Joe Testa has taken the exams but I don't know if he's gone through the books. I also know that Oracle people lurk on this list, perhaps one of them can check the docs with Oracle University? Worst case, I know some people IN Oracle University, perhaps I can get the info from them Rachel --- Karniotis, Stephen [EMAIL PROTECTED] wrote: Everyone: I am looking to all of my esteemed peers and gurus to clarify something that I know is blatantly wrong. Here is the scenario. I have a co-worker that is preparing for the DBA OCP debacle. They have completed a significant portion of the training and are preparing to take the first set of exams. To see what they have learned, I asked them to define what comprises an Oracle Instance and what comprises an Oracle database. Here are the responses I got: An Oracle Instance The database instance contains storage areas that allow users to use the database, data dictionary, redo log buffers and various processes that help to maintain, tune and run the database An Oracle Database The Database files consist of the parameter file or init.ora file, the physical data files, the control file and the redo log files and archived log files if the database is run in archive log mode Now, we all know that an Oracle instance comprises the background processes, the memory processes, memory storage areas, the and INIT.ORA parameters whereas the database comprises the physical files, data dictionary, users, objects, etc. The problem I have is the education is being supplied by our favorite vendor, Oracle. Did I go on vacation too long or is Oracle professing incorrect information in the OCP. Can one of the people that has taken the exam the classes look this up in the manuals for me? This proves my theory of refusing to take this exam unless hogwhipped and tied down (Rachel, sit down please and thanks for volunteering). If bad information is being given, then what's the use of the exam? Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karniotis, Stephen 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). __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: Simple favor from the guru's
Well this is from the 8.1.7 Doco Concepts guide Section introduction to an instance, and I quote This combination of the SGA and the Oracle processes is called an Oracle instance. It doesn't include the initora file, the concepts guide a bit further into it is this one To start an instance, Oracle must read a parameter file--a text file containing a list of configuration parameters (initialization parameters) for that instance and database. So if I read that correctly what we generally all refer to a database ie instance all files etc consists of three components: instance, database, and parameter file. After starting an instance, Oracle associates the instance with the specified database I refers to mounting the database so all things that are connected to an instance when you mount is the database. that would include all dbf file, redo, archive. That would make the alert log though part of the instance So now where did I go wrong Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Karniotis, Stephen [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 16-08-2002 05:18 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:Simple favor from the guru's Everyone: I am looking to all of my esteemed peers and gurus to clarify something that I know is blatantly wrong. Here is the scenario. I have a co-worker that is preparing for the DBA OCP debacle. They have completed a significant portion of the training and are preparing to take the first set of exams. To see what they have learned, I asked them to define what comprises an Oracle Instance and what comprises an Oracle database. Here are the responses I got: An Oracle Instance The database instance contains storage areas that allow users to use the database, data dictionary, redo log buffers and various processes that help to maintain, tune and run the database An Oracle Database The Database files consist of the parameter file or init.ora file, the physical data files, the control file and the redo log files and archived log files if the database is run in archive log mode Now, we all know that an Oracle instance comprises the background processes, the memory processes, memory storage areas, the and INIT.ORA parameters whereas the database comprises the physical files, data dictionary, users, objects, etc. The problem I have is the education is being supplied by our favorite vendor, Oracle. Did I go on vacation too long or is Oracle professing incorrect information in the OCP. Can one of the people that has taken the exam the classes look this up in the manuals for me? This proves my theory of refusing to take this exam unless hogwhipped and tied down (Rachel, sit down please and thanks for volunteering). If bad information is being given, then what's the use of the exam? Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karniotis, Stephen 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]
Re: Simple favor from the guru's
Lord knows I am one of the first to disparage the validity of OCP as a measure of what a DBA should/does really know... however, this is the reply I received from a friend who is an instructor at Oracle University. What they have learned, is NOT what they have been taught. The information this student provided is wrong and would be wrong an all versions of the ocp exam. I have provided notes from chapter one of the Oracle 9i DBA Fundamentals I course notes. Chapter 1 Page 3 Oracle Instance: An Oracle Instance is the combination of the background processes and memory structures. The instance must be started to access the data in the database. Every time an instance is started, a System Global Area (SGA) is allocated and Oracle background processes are started,. Background processes perform functions on behalf on invoking processes. They consolidate functions that would otherwise be handled by multiple Oracle programs running for each users. The background processes perform input/output and monitor other oracle processes to provide increased parallelism for better performance and reliability. Chapter 1 Page 3 Oracle database: An Oracle Database consists of operating system files, also known as database files. They provide the actual physical storage for database information. The database files are used to ensure that the data is kept consistent and can be recovered in the event of a failure of the instance. Chapter 1 Page 9 An Oracle database consist of three file types. Data files containing the actual data in the database, redo logs containing a record of changes made to the database to enable recovery of the data in case of instance failure, and control files containing information necessary to maintain and verify data integrity. Immediately after the definition of a database above is the heading Other Key File Structures, beneath this heading it says The oracle server also uses other files that are NOT part of the database: - The parameter file that defines the characteristics of an Oracle Instance For example it contains parameters that size some of the memory structures of the SGA. - The password file that authenticates users privileged to startup and shutdown an oracle instance (remotely) - Archived Redo log files are offline copies of the redo log files that may be necessary to recover from media failures. Hope this helps clear up any confusion, --- Karniotis, Stephen [EMAIL PROTECTED] wrote: Everyone: I am looking to all of my esteemed peers and gurus to clarify something that I know is blatantly wrong. Here is the scenario. I have a co-worker that is preparing for the DBA OCP debacle. They have completed a significant portion of the training and are preparing to take the first set of exams. To see what they have learned, I asked them to define what comprises an Oracle Instance and what comprises an Oracle database. Here are the responses I got: An Oracle Instance The database instance contains storage areas that allow users to use the database, data dictionary, redo log buffers and various processes that help to maintain, tune and run the database An Oracle Database The Database files consist of the parameter file or init.ora file, the physical data files, the control file and the redo log files and archived log files if the database is run in archive log mode Now, we all know that an Oracle instance comprises the background processes, the memory processes, memory storage areas, the and INIT.ORA parameters whereas the database comprises the physical files, data dictionary, users, objects, etc. The problem I have is the education is being supplied by our favorite vendor, Oracle. Did I go on vacation too long or is Oracle professing incorrect information in the OCP. Can one of the people that has taken the exam the classes look this up in the manuals for me? This proves my theory of refusing to take this exam unless hogwhipped and tied down (Rachel, sit down please and thanks for volunteering). If bad information is being given, then what's the use of the exam? Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access /
Re: Simple favor from the guru's
On Thu, 15 Aug 2002 16:48:27 -0800, you wrote: So if I read that correctly what we generally all refer to a database ie instance all files etc consists of three components: instance, database, and parameter file. Actually, strictly speaking, the parameter file is not considered part of the database. Jonathan Gennick --- Brighten the corner where you are mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick 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).