Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Beta OCP exam for 10g New Features

Beta OCP exam for 10g New Features

From: M Rafiq <rafiq9857_at_hotmail.com>
Date: Mon, 07 Jun 2004 12:13:34 -0400
Message-ID: <BAY99-F65dciOv2JOwF0000b96b@hotmail.com>


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
> -----------------------------------------------------------------
>



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
-----------------------------------------------------------------

_________________________________________________________________
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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US