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

Home -> Community -> Usenet -> c.d.o.server -> Re: spfile vs pfile in 9i

Re: spfile vs pfile in 9i

From: Fabrizio <fabrizio.magni_at_mycontinent.com>
Date: Sat, 23 Oct 2004 06:32:45 GMT
Message-ID: <4179FB09.1040301@mycontinent.com>

Richard Stanton wrote:
> Hello
>
> can anyone explain to me what the advantages of using spfiles are over
> the traditional pfiles? Is it just the ability to make changes to the
> database on the fly without editing files etc?
>
> Also, why are there so many pfiles created for each database in 9i,
> and what do they all do?
>
> I have a test database and the following pfiles have been created for
> it:
>
> oracle\ora92\database\inittest.ora
> oracle\ora92\sysman\ifiles\def_TEST.domain.co.UK.ora
>
> and this spfile:
>
> oracle\ora92\database\spfiletest.ora
>
>
> Richard

In a spfile I miss the old-fashioned comments who could be added in a pfile. :(

Regards

--
Fabrizio Magni

fabrizio.magni_at_mycontinent.com

replace mycontinent with europe

Received on Sat Oct 23 2004 - 01:32:45 CDT

Original text of this message

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