Re: Oracle 8i performance probs

From: Connor McDonald <>
Date: Mon, 18 Mar 2002 21:13:08 +0000
Message-ID: <>

Fax wrote:
> Hi guys, I would be grateful if I could get some help about this problem :
> Our main Oracle server seems to be more and more laggy, every terminal using
> apps tend to freeze for no apparent reason at some point everyday.
> We've ben told the tables would need a cleanup.
> Would that solve our problem ?
> If yes, what command should be used to initiate a
> cleanup ? (alter, etc..?)
> Thanks in advance!

Some guesses...

  • archiver not keeping up with lgwr
  • redo logs too small
  • shared pool fragmentation
  • poor SQL

all of which can cause "random" freezes in the environment


Connor McDonald

"Some days you're the pigeon, some days you're the statue..."
Received on Mon Mar 18 2002 - 22:13:08 CET

Original text of this message