Oracle Audit/Health Check

Companies who use the Oracle RDBMS to host business applications recognize that database administration is an essential part of the on-going care and maintenance.  Many of these applications may be business critical. 

As new applications come on-line, older applications are retired and existing applications are modified (and/or grow in usage and complexity) the physical and logical disposition of the various Oracle components can become less efficiently organised.   Often performance can become adversely affected. 

Strategically it may pass unnoticed that existing business problems could be addressed by improving inter-application interfacing via Oracle functionality.  "Bridging" between Oracle databases could provide improved or badly needed "enterprise wide" and/or Decision Support Solution reporting. 

A worst case scenario could include inadequate future proofing of existing Oracle based applications. 

In order to assess potential problems and provide meaningful solutions, Britannic Data Solutions has formulated an Oracle Audit which comprises the following activities: 

1. On-site review of all Oracle applications 

  • Oracle RDBMS configuration check
  • review of fragmentation
  • capacity usage and forward loading assessment
  • performance analysis
  • future proofing and application life cycle analysis
  • Oracle licensing and upgrade review

2. On-site review of business activity and back-up capability 

  • back-up strategy review
  • disaster recovery capability assessment

3. On-site review of corporate reporting needs 

  • review of existing reporting
  • assessment of enterprise wide reporting opportunity
  • decision support software applicability review

4. Business process inter-dependency analysis 

  • review of Oracle based business applications
  • assessment of opportunities for inter-application interfacing or rationalization

5. Preparation of post-audit recommendations and report 

  • performance and configuration recommendation
  • capacity, hardware and future proofing
  • licensing and upgrade

6. Implementation of audit recommendations as required. 
 

Back to Overview

Enterprise Reporting

Oracle Database Administration 

Contract Software Development Services 

Contract Project Management Services