Re: Frequency of Analyze

[Bunyamin K. Karadeniz]

Title: Frequency of Analyze

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   ----- Original Message ----- From: Arslan Dar To: 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 [EMAIL PROTECTED] Database Administrator Shaukat Khanum Memorial Cancer Hospital & Research Centre www.shaukatkhanum.org.pk