Re: spfile vs pfile in 9i

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Fri, 22 Oct 2004 16:08:20 +0100
Message-ID: <41794290$0$10003$cc9e4d1f@news-text.dial.pipex.com>

"Richard Stanton" <richardpstanton_at_yahoo.com> wrote in message news:87bc8a5f.0410132342.64e5a5bf_at_posting.google.com...

> richardpstanton_at_yahoo.com (Richard Stanton) wrote in message 
> news:<87bc8a5f.0410120846.75eeb98e_at_posting.google.com>...

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

dynamic changes without restart is one.
ability to control multiple instances from one file.

>>
>> 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
>> oracle\admin\test\pfile\init.ora
>>
>> and this spfile:
>>
>> oracle\ora92\database\spfiletest.ora
Received on Fri Oct 22 2004 - 10:08:20 CDT