I haven't like SPFILEs either -- haven't got used to them. When I do use
an SPFILE, I have a backup initsid.ora pfile available.
Hemant
At 01:29 PM 30-06-03 -0800, you wrote:
And another thing. If in pre 9i days you tried to allocate more than 2gb
to the Oracle.exe process, just cause you have 9i
And another thing. If in pre 9i days you tried to allocate more than 2gb
to the Oracle.exe process, just cause you have 9i and dynamic memory
allocation does not mean that os limits have disappeared. Your text file
(init.ora) with the incorrect value in it to edit on the other hand,
has.