Issue the below command:

SQL>Alter system set shared_pool_size=<value in MB> scope=spfile; (if u
are using spfile)

Azad
----- Original Message -----
From: "M.Shahbaz " <oracledba-ezmlmshield-x20864191.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Wednesday, March 05, 2008 1:58 PM
Subject: Re:


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