Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> change the LAST_ANALYZED date
Hi all,
Have you encountered this problem before:
On 9.2.0.8 if an index's last_analyzed date is set to a future date, the GATHER_INDEX_STATS will not work. The index statistics are not regenerated if the operating system date is less then the index's last_analyzed date. No error messages are displayed either. But the GATHER_TABLE_STATS works regardless of last_analyzed date!
Is there a way of tweaking the last_analyzed date? I see there's a SET_INDEX_STATS procedure, but it doesn't cater for the LAST_ANALYZED date. If I could reset the last_analyzed date to something older than today, perhaps the gather_index_stats will work!!
Thanks,
Leng.
Leng Kaing
Senior Oracle DBA
Hansen Technologies; 2 Frederick St; Doncaster 3108
Ph: +61-3-9840-3832
Notice:
This e-mail and any attachments are confidential and may contain legally privileged information and/or copyright material of Hansen Technologies Limited or third parties. Copying, distributing, disclosing, commercialising or otherwise acting in reliance on this e-mail and any attachments is strictly prohibited unless you are the addressee of this e-mail and have written permission to do so. If you have received this e-mail in error please delete this e-mail (including any copies and attachments) and contact Hansen Technologies Limited by return e-mail or by telephone on + 61 3 9840 3000. Any views expressed in this e-mail are those of the individual sender and may not necessarily reflect the views of or be a commitment by the organisation, except where the individual sender has the authority and expressly states them to be so.
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Dec 14 2006 - 23:31:45 CST
![]() |
![]() |