Findings on a database!

[suddhasatwa_bhaumik]

Hello Tim

Good Morning.

Let's assume that you're invited to my organisation to look into my platform, which has thousands of databases if not less, and you are requested to check various aspects of these databases to tell me where I am going wrong w.r.t administration, health checks, backups, etc.

What would be the points that you'd cover during such an excercise?
E.g., how the backups are being taken? What parameters to monitor day by day? Script(s) to identify bad queries? Etc ..

Some suggestions in this regard would be really helpful.

Thanks,

Suddhasatwa

[Tim...]

Hi.

Probably the easiest way to approach a health check is to follow this note from MOS:

https://support.oracle.com/epmos/faces/ ... d=122669.1

It's got most of the major steps you should consider.

The backups are a little more tricky to advise on because it is so dependent on the system. You have to consider DB size, performance, mean time to recovery etc. It's something you need to discuss on a per-database basis.

Cheers

Tim...