Step 1. login through sysdba and check the shared pool size :--> SQL>show
parameter shared_pool_size; (this will show the current shared_pool_size
value)
Step 2. SQL>Alter system set shared_pool_size=<new value in KB or MB>
scope=spfile;


Azad


----- Original Message -----
From: "YONGLONG_LI"
<oracledba-ezmlmshield-x89206316.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Wednesday, March 05, 2008 2:34 PM
Subject: RE: I give up (dynamic plsql)


> Dear All:
> How can I increase the value of shared_pool_size online?
>
> -----Original Message-----
> From: kazi
> [mailto:oracledba-ezmlmshield-x47754945.[Email address protected]
> Sent: Wednesday, March 05, 2008 5:02 PM
> To: LazyDBA Discussion
> Subject: Re: I give up (dynamic plsql)
>
> Why dynamic sql? It is more complicated and slower!
>
> I would use sometthing like :
>
> dat date;
> ...
> dat := '06-02-2007';
> LOOP
> ...
> INSERT INTO scott.emp_test SELECT * FROM scott.emp WHERE a.hiredate
> < sysdate+1;
> ...
> dat := dat+1;
> EXIT WHEN dat > '02-02-2008' ;
> END LOOP;
>
> Well I don't see a point of "day by day" if tha day is not envolved in
> your transaction.
> Or maybe you replace "< sysdate+1" with "= dat"
>
> KAzi
>
> ab265 wrote:
> > Experts,
> >
> > For god sake help me doing that. I am trying to insert date from
> table to
> > table depending on specific date. I want to do the following:
> >
> > 1- select date from 06-02-2007 day by day to 02-02-2008.
> > 2- insert into another table day by day (one by one).
> >
> > Best result i am looking for is a statement like the one below. It
> didn't work
> > actually. I have been trying for a long time. I need to supstitue
> sysdate in the
> > code withe specific date like 06-02-2007.
> >
> > I want this dynamic sql to run. For god sake, help me.
> >
> > select 'INSERT INTO scott.emp_test SELECT * '|| FROM scott.emp || '
> WHERE
> > a.hiredate' ||' ' < ' || sysdate + 1 ;
> >
> > Thanks,
> >
> >
> >
> >
> > ---------------------------------------------------------------------
> > 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