Hi ,
After the announcement of Beta OCP exam for 10g New features, I am planning
to appear in that exam on July 11,2004.
I already have 10g new features book by Mike Ault and ordering book by
Robert Freemen. Is there any other stuff on internet available (except
Oracle Docs).
Any help?
If you are interested to appear, use OPP code to save some money...
Regards Rafiq
From: Niall Litchfield <niall.litchfield@xxxxxxxxx> Reply-To: oracle-l@xxxxxxxxxxxxx To: oracle-l@xxxxxxxxxxxxx Subject: Re: Oracle 9.2 changes in INIT Date: Mon, 7 Jun 2004 17:03:11 +0100
There is a nice explanation at http://www.dizwell.com but to answer your question
where parameter is the parameter for example OPEN_CURSORS, value is the new value you want for example 500 and scop takes one of MEMORY which means make the change just to the currently running instance , SPFILE which means make the change to the SPFILE making it persistent or BOTH which fairly obviously means do both of these.
It also takes COMMENT= and then a comment so that you can document your changes, but obviously this option is almost never used :( .
I don't like them much but they do have a bunch of advantages (principally as a mechanism for self tuning and for RAC) and get to be mandated for various new features. To back them up - which is wise as the error checking leaves something to be desired and can leave you with a non startable instance and a non editable init.ora if you do things stupidly (or you experiment with new things in a perverse manner) - then either backup the file using an os utility or use the new CREATE PFILE <FILENAME> FROM SPFILE <filename> syntax to create an old fashioned plain text init.ora
Niall Litchfield Oracle DBA http://www.niall.litchfield.dial.pipex.com
On Mon, 7 Jun 2004 10:53:15 -0500, Smith, Ron L. <rlsmith@xxxxxxx> wrote: > > > I am setting up my first new 9.2 database. When I looked at the > init(sid).ora it looks like there is some binary code at the front and > end of the file. How do you edit the file now? > > Thanks! > Ron Smith > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- > ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------
---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------