On 2003.11.24 01:34, VirVit wrote: > Hello. > > I'am a newbie in Oracle, so I have some questions to experts :) > > 1) What difference between SPFILE and PFILE?
Big one. It's best described in the concepts manual as well as in the DBA guide. To make long story short, you can modify SPFILE from sqlplus which is not possible with PFILe. SPFILE is "binary" (quotes are here because it's not very binary, just a little), while PFILE is a standard text file. > 2) Where by default Oracle search these files when instance starts? In %ORACLE_HOME%\DBS directory. > 3) Where oracle searches datafiles by default? Nowhere. It doesn't search them. Locations of the control files are a mandatory parameter in the parameter file (PFILE and SPFILE) and control files contain, among other things, locations of all data, temporary and redo log files. > 4) Sorry for lame questions :( No problem. There is plenty of literature available on OTN (technet.oracle.com) as well as in the bookshops just across the wire, like http://www.bn.com (Barnes & Noble). Oracle has a site, maintained by the book writer of the year (no, it's not Cary Millsap, it's like NFL, the best team never wins. I have quite a few funny stories about NFL and being dead certain that I know which team will win, but this is not an NFL mailing list). The site is http://asktom.oracle.com. It's maintained by Tom Kyte who answers as many questions as humanly possible. Not all answers are useful, but all are factually correct. The good books to read are probably 1) Oracle9i DBA Handbook by Kevin Loney and Marlene Theriault (don't shoot, Rachel, it's French!) 2) Expert 1-on-1 , Tom Kyte 3) Practical Oracle 8i (one of the best DBA books ever written, even for a beginner, pertinent for version 9i as well), written by J. Lewis 4) Oracle Administratiion and Management by M. Ault (don't buy Oracle8i Admin. and Mgmt. as it is obsolete. the second edition is much better) There are other good books, which are not, in my opinion, suitable for a beginner. 1) Cary Millsap: Optimizing Oracle Performance (excellent book) 2) Gaja V., Kirti Deshpande, John Kostelac 101 Oracle Performance Tuning (really great book) 3) Guy Harrison Oracle SQL High Performance Tuning The mandatory parts of the DBA arsenal are also Robert Freeman's RMAN book, Don Burleson's Statspack book and last but least, Andy Duncan, Jared Still: Perl for Oracle DBAs (just for the lovers of the pathologically eclectic rubish lister) > > Oracle 9.2.0.4, win2k. It's not your fault. You may want to try with Linux, though. > > -- > ÐÐÑÐÐÑÐÐ ÐÐÑÐÐÐÐ ÐÐÐÑÐÐÐÑ (VirVit) > Oracle 9i DBA beginner > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: VirVit > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > 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). > -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
