RE: New to Oracle 9i...Increasing SGA parameters.

From: oranix9i <oranix9i_at_bonbon.net>
Date: Thu, 15 Jul 2004 12:00:13 +0530
Message-ID: <PNEPKGEKDHGPFKGFFKIACEBDCAAA.oranix9i@bonbon.net>

I am quite sure that ur system is taking the values from spfile and not from init<sid>.ora try creating an spfile based on ur init<sid>.ora it will solve ur prob.
Nix

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Paul Drake Sent: Thursday, July 15, 2004 12:01 PM
To: oracle-l_at_freelists.org
Subject: RE: New to Oracle 9i...Increasing SGA parameters.

• Denham Eva <EVAD_at_TFMC.co.za> wrote:
  > Many Thanks for the input...
  >
  > 9.2, right? <- Yes!
  >
  > > how about nuking the entire deal and selecting a %
  > of
  > > physical memory for oracle to allocate?
  > > it involves the least amount of thinking.
  > > for a single database instance, give it half.
  > This is what I am trying to do! I started with
  > creating an init.ora, by
  > copying what appears to be an example file
  > init.ora.42920039208 and
  > editing it. The SGA remained the same, I then tried
  > copying init.ora to
  > init<SID>.ora. SGA still stays the same.
  > Pretty frustrating!
  

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

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
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 - 02:02:01 CDT