Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: New to Oracle 9i...Increasing SGA parameters.
by default, dbca creates an spfile and then cycles the instance to use it. you may be juggling the numbers in the pfiles, but the database instance is likely reading the spfile and acting accordingly.
check %ORACLE_HOME%\database for
spfile%ORACLE_SID%.ora.
also,
SQL> show parameter spfile
Pd
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Thu Jul 15 2004 - 01:27:55 CDT
![]() |
![]() |