Findings on a database!

All posts relating to Oracle database administration.

Moderator: Tim...

Posts: 3
Joined: Thu Nov 15, 2012 5:53 am

Findings on a database!

Postby suddhasatwa_bhaumik » Fri Nov 16, 2012 3:25 am

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.



Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: Findings on a database!

Postby Tim... » Fri Nov 16, 2012 9:15 am


Probably the easiest way to approach a health check is to follow this note from MOS: ... 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.


Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website:
My blog:

Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 3 guests