Re: Schedule a flush shared pool

From: Tim Arnold <timkarnold_at_comcast.net>
Date: Sun, 4 Apr 2004 15:47:26 -0400
Message-ID: <arqdnfGklfMo-O3dRVn-iQ@comcast.com>

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

We were seeing a slew of ora-4031 in the alert log. Received on Sun Apr 04 2004 - 14:47:26 CDT