Keeping them binary gives them "power" I guses...
On most platforms there is just a hashed value on the first line.
In 9i R1 (9.0.1), I was able to replace some param value without changing number of chars on the
line, and the changes were taken without any problem (HP-UX 11, it was I think). Could not believe
that it worked. No such luck in 9i R2...
Binary, text, whatever, I will just stay away from him till pfile really goes away :)
- Kirti
- "Jamadagni, Rajendra" <Rajendra.Jamadagni_at_espn.com> wrote:
> it isn't binary on solaris ... pure text ...
>
> Raj
>
> -----Original Message-----
> Sent: Wednesday, July 16, 2003 6:40 PM
> To: Multiple recipients of list ORACLE-L
> sync with INIT.ORA ?)
>
>
> I can definitely appreciate the benefits of dynamic parameters, and of being
> able to persist the values of those parameters accross shutdown/startup
> cycles. But I would have guessed that oracle could have gotten both of
> those features together without going to a binary parameter file--couldn't
> whatever process writes to the spfile just write to a plain text file
> instead? Does anybody know what the advantage of having a binary store of
> params is?
>
> Cheers,
> -Roy
> > ********************************************************************This e-mail message is
> confidential, intended only for the named recipient(s) above and may contain information that is
> privileged, attorney work product or exempt from disclosure under applicable law. If you have
> received this message in error, or are not the named recipient(s), please immediately notify
> corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank
> you.*********************************************************************2
>
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
Received on Wed Jul 16 2003 - 21:25:37 CDT