Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!news.moat.net!border1.nntp.sjc.giganews.com!nntp.giganews.com!local1.nntp.sjc.giganews.com!nntp.comcast.com!news.comcast.com.POSTED!not-for-mail
NNTP-Posting-Date: Sun, 04 Apr 2004 14:44:53 -0500
Reply-To: "Tim Arnold" <timkarnold@comcast.net>
From: "Tim Arnold" <timkarnold@comcast.net>
Newsgroups: comp.databases.oracle.misc
References: <nSebc.34699$zm5.14577@nntpserver.swip.net> <0_adnTYQ-t564_DdRVn-jA@comcast.com> <406d811e$0$6547$ed9e5944@reading.news.pipex.net>
Subject: Re: Schedule a flush shared pool
Date: Sun, 4 Apr 2004 15:47:26 -0400
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Message-ID: <arqdnfGklfMo-O3dRVn-iQ@comcast.com>
Lines: 35
NNTP-Posting-Host: 68.55.20.138
X-Trace: sv3-cO7RAa/NR/WVg9cJ7H14azTIF2xAOtd8R2okqR0dWv/ybB/r2JOX8NUU9H/gelXqpiet2ExLMDPTgcg!vBoknppgo+SRFt6insALK5gRuqPF1RIOBsMlp/TdXZ1cVCUB8FT1JRoCOvKm
X-Complaints-To: abuse@comcast.net
X-DMCA-Complaints-To: dmca@comcast.net
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly
X-Postfilter: 1.1
Xref: newssvr20.news.prodigy.com comp.databases.oracle.misc:137405


"Niall Litchfield" <n-litchfield@audit-commission.gov.uk> wrote in message
news:406d811e$0$6547$ed9e5944@reading.news.pipex.net...
> out of curiosity really why?
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> "Tim Arnold" <timkarnold@comcast.net> wrote in message
> news:0_adnTYQ-t564_DdRVn-jA@comcast.com...
> >
> > "Ed Zeppelin" <fhnfhn@hotmail.com> wrote in message
> > news:nSebc.34699$zm5.14577@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.