Oracle database administration and support    
 

Oracle Database Health Check

Installation of all scripts required to perform a health check of an Oracle Database instance at the customer's UK location. The health check also covers configuration, security and file location (where possible conforming to Oracle's Optimal File Architecture).

An initial planning meeting will be held with the customer to confirm the system configuration before any work is undertaken. This service also includes full documentation detailing the system configuration.
Oracle database health check

Benefits

  • Professional Health Check by an Oracle Certified Professional
  • On-site configuration assessment
  • Documentation detailing how the system has been configured and how it can be tuned
  • End to end professional service
  • Professional report detailing all actions to be taken to correct all problems highlighted

Definition


All of the following areas will be investigated and a detailed report generated to highlight potential problems.
  • Redo log file size/location
  • Control file multiplexing
  • Invalid objects
  • Segment placing
  • Optimizer options/object analysis
  • Rollback segment usage
  • Users - roles granted/security
  • License details
  • Options installed
  • Compatibility
  • Chained/migrated rows
  • Invalid constraints
  • Database errors
  • Alert log monitoring
  • Objects within n extents of their maximum number of extents
  • Objects that would grow beyond the limits of the tablespace if they grew by more than n extents
  • Table/indexes that need reorganization
  • Files/tablespaces online

Related Installation Services

Oracle RDBMS Installation
 
Administr8ors Ltd | Fern Bank | Copster Green | Blackburn | Lancs | BB1 9EP
E:
Oracle certified professional.