| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Beta OCP exam for 10g New Features
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_at_gmail.com>
Reply-To: oracle-l_at_freelists.org
To: oracle-l_at_freelists.org
Subject: Re: Oracle 9.2 changes in INIT
Date: Mon, 7 Jun 2004 17:03:11 +0100
Welcome to the wonderful world of the SPFILE discussed here recently.
There is a nice explanation at http://www.dizwell.com but to answer your question
ALTER SYSTEM has acquired some new functionality. You can now issue
ALTER SYSTEM SET <parameter> = <value> SCOPE=<SCOPE>;
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
cheers
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
On Mon, 7 Jun 2004 10:53:15 -0500, Smith, Ron L. <rlsmith_at_kmg.com> 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_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- _________________________________________________________________ Watch the online reality show Mixed Messages with a friend and enter to win a trip to NY http://www.msnmessenger-download.click-url.com/go/onm00200497ave/direct/01/ ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Mon Jun 07 2004 - 11:12:10 CDT
 |
 |