I'm assuming that you are running on 10g.

Here is a list a parameters and there settings(that I think are the major ones):

Initialization Parameter Value

SHARED_POOL_SIZE 0
LARGE_POOL_SIZE 0
JAVA_POOL_SIZE 0
DB_CACHE_SIZE 0
STREAMS_POOL_SIZE 0
LOG_BUFFER MAN
DB_KEEP_CACHE_SIZE DB_RECYCLE_CACHE_SIZE MAN
DB_nK_CACHE_SIZE MAN
SGA_TARGET <= SGA_MAX_SIZE MAN
SGA_MAX_SIZE MAN
PGA_AGGREGATE_TARGET MAN
SORT_AREA_SIZE IGN
HASH_AREA_SIZE IGN
BITMAP_MERGE_AREA_SIZE IGN
CREATE_BITMAP_AREA_SIZE IGN

MAN: Needs to be evaluated and assigned a value.
IGN: Any value assigned will be ignored.

0: if you put a value here then ORACLE will at least reserve that amount of memory.

Hope it helps.

>Merci / Thanks
>Yves Leonard,
>Chef de Projet / Project Leader,
>DDS / SDD,
>RH Coats, 13-I
>Télép>ĥ>one / phone : 613-951-3233,
>couriel / email : yves.[Email address protected]
>

-----Original Message-----
From: Sikyala Raquel [mailto:oracledba-ezmlmshield-x73035167.[Email address protected]
Sent: February 1, 2007 9:29 AM
To: LazyDBA Discussion
Subject: RE: Shared pool size in Megabytes


Thanks. Now I am having a problem with my sga. The total size is
135353968 and I need to increase it in order to increase my shared pool
size. How do I fix the sga_max_size so that I can increase the
shared_pool_size?
-----Original Message-----
From: Parveen Kumar [mailto:[Email address protected]
Sent: Wednesday, January 31, 2007 5:40 PM
To: Sikyala, Raquel
Subject: Re: Shared pool size in Megabytes

**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email, **and removed
any attachments, and kept your email address secret **from this person,
and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal **Anything below this line is the original email text


this is in bytes , divide it by 50331648/1024/1024=48M

cheers

Parveen

Sikyala Raquel wrote:
> I am trying to find out if my shared_pool_size and java_pool_size is
> 150M. when I type show parameter shared_pool_size for example the
> value is 50331648. I don't know how to determine the size in
> megabytes. Could someone help me please?
>
> Raquel Sikyala
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post

> a dba job: http://jobs.lazydba.com To Subscribe :
> http://www.LazyDBA.com To unsubscribe:
> http://www.lazydba.com/unsubscribe.html
>
>


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page