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

Oracle LazyDBA home page