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
>
>

Oracle LazyDBA home page