50-Point Health Check

Remote Control DBA supports over 600 Databases on six continents. Our vast experience and expertise in database support makes us an expert in spotting potential problems for a production database. For a limited time, we are offering a 50-point health check at the rate of $200/DB.

The health check should take no more than three-hours per DB; most can be done in two hours. We require access to the oracle owner account on the operating system and to sys in the DB to complete the health check. The check should be done during peak-utilization periods and is not invasive.

The key advantages to the 50-point health check are:
  • Prevent downtime caused by outages that could have been easily prevented
  • Identify possible security issues
  • Identify possible performance bottlenecks
  • Peace of mind that your DB is running optimally is free of any foreseeable problems
The 50-point health check includes:

  • optimizer configuration
  • optimal pga configuration
  • optimal sga configuration
  • optimal uga configuration
  • optimal redo log size
  • optimal log buffer setting
  • optimal undo retention
  • optimal DBWn configuration
  • optimal DB Cache configuration
  • optimal parallelism configuration
  • optimal file layout
  • optimal tablespace definitions
  • optimal SQL*Net configuration
  • optimal pctfree and pctused settings
  • optimal pctincrease settings
  • optimal extents/extent size for objects
  • cpu utilization
  • disk I/O utilization
  • network I/O utilization
  • RAM/swap utilization
  • free space
  • space allocated vs. space used
  • Oracle file security
  • object security
  • schema security
  • current patch level
  • alert log review
  • listener log review
  • inconsistent datafiles
  • corrupt data blocks
  • datafile backup review
  • controlfile backup review
  • archive log configuration
  • user profiles
  • user grants
  • extensibility of datafiles
  • extensibility of database objects
  • chained/migrated rows
  • tablespace allocation
  • invalid oracle packages
  • invalid user objects
  • percent sorts to disk
  • identify indexes that need to be rebuilt
  • optimal process/session/lock thresholds
  • Ten longest-running statements
  • Ten most resource-consuming statements
  • utl_file usage and configuration
  • queue loads
  • statistics
  • sources of contention

Got additional concerns? Feel free to add them. We are happy to discuss including anything else you would like to have checked in addition to our standard health check.

After the health check is complete you will be presented with a short, easy to read report that highlights what fixes are needed and what areas should be investigated further.

For more information, contact sales@remotecontroldba.com.