I believe there is a thread on either this archive or on ask Tom that
goes over the pros and cons in detail.
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?
>
> 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
>
> thanks for your help
>
> Richard
Received on Wed Oct 13 2004 - 08:21:24 CDT
