Thanks!

-----Original Message-----
From: Hudspith Adam [mailto:[Email address protected]
Sent: Thursday, February 01, 2007 9:35 AM
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 useful if you want to see the current memory structures in
Megabytes:

col Meg for 99999.99

select pool, name, bytes/1024/1024 "Meg"
from v$sgastat
where name in ('free memory', 'db_block_buffers', 'memory in use',
'sql area', 'buffer_cache',
'dictionary cache',
'library cache')
order by name
/

Change the sga_max_size in your initSID.ora file ... or via "alter
system"
if using an spfile.

-----Original Message-----
From: Sikyala Raquel
[Email address protected]
Sent: 01 February 2007 14:29
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

************************************************************************
****
****
IMPORTANT NOTICE

House of Fraser (Stores) Limited
Registered office: Granite House, 31 Stockwell Street, Glasgow G1 4RZ
Company Number: 10677 Registered in Scotland

If you have received this e-mail in error, please notify the sender and
delete the e-mail and attachments immediately. This e-mail (including
any
attachments) may contain confidential and/or privileged information. If
you are not the intended recipient, any reliance on, use, disclosure,
dissemination, distribution or copying of the e-mail or attachments is
strictly prohibited.
We have checked for viruses but the content of an attachment may still
contain software viruses, which could damage your computer system. We do
not accept liability for any damage you sustain as a result of a virus
introduced by this e-mail or attachment and you are advised to use
up-to-date virus checking software. E-mail transmission cannot be
guaranteed to be secure or error free.
This e-mail is not intended nor should it be taken to create any legal
relations, contractual or otherwise.
To view our latest in-store news click on:
http://www.houseoffraser.co.uk

************************************************************************
****
****

Oracle LazyDBA home page