RE: New to Oracle 9i...Increasing SGA parameters.
- From: Mark Burgess <mburgess_nz@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 15 Jul 2004 16:27:22 +1000 (EST)
Sounds like the database is being started up with
spfile if the changes to the init.ora are not being
picked up.
Try using OEM Console to set the instance memory
parameters which will populate the spfile with the
correct values and the current running instance.
--- Denham Eva <EVAD@xxxxxxxxxx> 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!
>
> Is the size then based on sga_max_size ??
>
----------------------------------------------------------------
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
>
----------------------------------------------------------------
> To unsubscribe send email to:
> oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at
> //www.freelists.org/archives/oracle-l/
> FAQ is at
> //www.freelists.org/help/fom-serve/cache/1.html
>
-----------------------------------------------------------------
>
Find local movie times and trailers on Yahoo! Movies.
http://au.movies.yahoo.com
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
