Re: Frequency of Analyze

From: Bunyamin K. Karadeniz <bunyamink_at_havelsan.com.tr>
Date: Fri, 15 Feb 2002 08:55:41 -0800
Message-ID: <F001.004111AE.20020215083325@fatcity.com>

It is due to your data change. If small number of of data change occurs you may need to do it monthly . But

I have read somewhere that Analyze is recommended for every week for oltp databases.

Bunyamin

<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">

Original Message -----
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: Arslan Dar To: <A href="mailto:ORACLE-L_at_fatcity.com" title=ORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L Sent: Friday, February 15, 2002 5:23 PM Subject: Frequency of Analyze

  What is the recommended
  frequency of analyzing schemas in an OLTP environment?   DB size near 8 GB. Oracle
  8.1.7.0.0 on NT 4.
  Arslan Zaheer
  Dar
<A

  href="mailto:arslandar_at_skm.org.pk">arslandar_at_skm.org.pk   Database Administrator
  Shaukat Khanum Memorial Cancer Hospital &   Research Centre
<A

  href="http://www.shaukatkhanum.org.pk">www.shaukatkhanum.org.pk    Received on Fri Feb 15 2002 - 10:55:41 CST