Hi Dear ,
Could you plz tell me how to increase the " SHARED_POOL_SIZE " value in
details .
Thanks alot for your kind co-operation

----- Original Message -----
From: "Surachart Opun "
<oracledba-ezmlmshield-x78001220.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Wednesday, March 05, 2008 11:22 AM
Subject: [Email address protected] - Number of numbers in MIME From exceeds
maximum threshold - Re:


> Oracle 9i haven't sga_target
>
>
> You need to increase *SHARED_POOL_SIZE* value.
>
>
>
> M.Shahbaz wrote:
>> Hi Dear
>> I am using Oracle 9i on operating system Window 2003 server
>>
>> I used show parameter sga_target but giving message unknown SHOW
>> option
>> "sga_target"
>>
>> ----- Original Message -----
>> From: "Surachart Opun "
>> <oracledba-ezmlmshield-x29831123.[Email address protected]
>> To: "LazyDBA Discussion" <[Email address protected]
>> Sent: Wednesday, March 05, 2008 10:20 AM
>> Subject: [Email address protected] - Number of numbers in MIME From
>> exceeds
>> maximum threshold - Re: How to increase shared memory
>>
>>
>>
>>> What version do you use?
>>>
>>> And Check Oracle Parameter
>>>
>>>
>>> 10G=>
>>>
>>> SQL> show parameter sga_target;
>>> sga_target big integer 7G
>>>
>>> if sga_target > 0 , you need to change sga_max_size and sga_target
>>> initialized parameters.
>>>
>>> SQL> alter system set sga_max_size=10G scope=spfile;
>>>
>>> SQL> alter system set sga_target=10G scope=spfile;
>>>
>>> If you have used spfile.
>>> SQL> show parameter spfile
>>>
>>> NAME TYPE VALUE
>>> ------------------------------------ -----------
>>> ------------------------------
>>> spfile string
>>> +ARCH/bedb/spfilebedb.ora
>>>
>>>
>>> If you haven't used spfile. you need edit pfile in ORACLE_HOME/dbs/ dir
>>> for Unix.
>>>
>>> Anyway If sga_target = 0, you need to change shared_pool_size
>>> initialized parameter.
>>>
>>>
>>> Before you increase the shared memory, you should know Share max size in
>>> your OS.
>>>
>>> M.Shahbaz wrote:
>>>
>>>> Hi Gurus,
>>>> While generating a report I am getting this error:
>>>> ORA-04031 - Unable to allocate string bytes of shared memory
>>>> ("string","string","string" )
>>>> When I checked this error I found - "More shared Memory is needed than
>>>> was allocated in the shared pool .
>>>>
>>>> So, could any one tell me how to increase the shared memory .
>>>> Looking for your valuable advise.
>>>>
>>>> Bazz
>>>>
>>>>
>>>> ---------------------------------------------------------------------
>>>> 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
>>>
>>>
>>>
>>
>>
>>
>> ---------------------------------------------------------------------
>> 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