Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> DO or DONT Analyze SYS Objects ?
Hello,
we are running Oracle 8171 using the CBO (Cost Based Optimizer).
I'm currently setting up a cron job to do a analyze on "all" objects
on a regular basis.
Now i have 2 Questions:
Any Hints ?
Thanks
Andreas Wizemann Received on Thu Dec 27 2001 - 02:17:22 CST