"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
news:406d811e$0$6547$ed9e5944_at_reading.news.pipex.net...
> out of curiosity really why?
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> "Tim Arnold" <timkarnold_at_comcast.net> wrote in message
> news:0_adnTYQ-t564_DdRVn-jA_at_comcast.com...
> >
> > "Ed Zeppelin" <fhnfhn_at_hotmail.com> wrote in message
> > news:nSebc.34699$zm5.14577_at_nntpserver.swip.net...
> > > Hi !
> > > I'd like to schedule an "alter system flush shared pool;", preferrably
> by
> > > using dbms_job. Anyone got any suggestions on how to do this, 'cause
I'm
> > out
> > > of ideas, my knowledge isn't enough
> > >
> > > Thanks!
> > >
> > >
> >
> > We do it through OEM - very straight forward
> >
> >
>
>
My guess is the application doesn't use bind variables. So they need to
flush all the useless cached SQL statements. It would be better to use bind
variables.
Jim
Received on Fri Apr 02 2004 - 10:03:11 CST
