Originally posted by jlakhani
Oracle should be standard thruout company.l
I disagree. Each and every database has different requirements as to the volume of data, update frequency, time to recover, etc., etc. Without more specifics, the answer is "It Depends."

In a heavy OLTP shop where a large percentage of the data changes daily, an analyze every night would not be unreasonable. In an OLTP shop where only a small percentage of the data changes on a daily basis, analyzing once a week may be sufficient.

I prefer that all production OLTP database be backed up at least once a day. DW should be backed up after the data changes.