| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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: Stephen.Karniotis_at_Compuware.com 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,
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: wisernet100_at_yahoo.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). ********************************************************************* The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: lerobe_at_acxiom.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). 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: Stephen_Karniotis_at_compuware.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).Received on Fri Aug 16 2002 - 09:39:05 CDT
 |
 |