Data is one of the most valuable and fastest growing resources in nowadays enterprises the management of it therefore merits serious consideration.

The IT Channel Database Management team is staffed with analysts and engineers that have extensive experience in the business and database management. We are focused on helping our clients in the following areas:

Oracle Database Assessment Services
Service Highlights
· Evaluate the healthiness of individual database for production operations
· Identify the potential risks or deficiencies in the database
· Improve the system efficiency by identifying fine-tuning opportunities

Statement of Work
· Oracle Products Review
· Oracle software product releases review
· Patch level review
· Documentation on enabled product options
· Certification matrix review
· Licensing verifications & review

System Review
· CPU & memory resources utilization review
· Database services utilization review
· Storage capacity review
· Documentation on datafile storage configuration
· Documentation on high level system diagram
· Database log review

Database Instance Review
· Instance parameter settings review
· Instance statistics review
· Instance bottleneck identification
· Instance tuning advice

Database Structure Review
· Database layout review
· Database physical location review
· Tablelspace/datafile storage setting review
· Database storage utilization
· Database fragmentation
· Object (i.e. table, index, etc) structure review
· Oracle database structure usage reviews, e.g. rollback segment, online redo logs etc.

Heavy SQL Identifications
· Identify top resources intensive SQL
· SQL extraction
· Identify utilization of variable binding of SQL statements

Database Availability & Integrity Strategy Review
· High level understanding and comment on
· Backup & recovery strategy
· High availability strategy
· Disaster recovery strategy
· Monitoring strategy
· Security strategy

Real Application Cluster Review
· RAC interconnect configuration review
· RAC related parameter review
· RAC statistics review
· CRS configuration review

Automatic Storage Management Review
· ASM instance configuration review
· ASM disk configuration review, e.g. mirroring, failure group

Delivery Methodology
IT Channel's Oracle database specialist will

Information Collection for the Express Healthcheck, by
· Interview with your staff
· Review the necessary system documents
· Connect and investigate the system directly

Complete the Oracle Database Express Healthcheck Report
· Report of findings
· Recommendations

Wrap Up Meeting
· Walk through the high risk area and problems, and their corresponding
· recommendations

After the completion of this comprehensive database healthcheck, if further in-depth reviews in any particular area or solution implementations are required, one can be arranged in form of separate projects.

Deliverables
· One standard database healthcheck report
· Wrap up meeting to walk though the findings and recommendations

IT Channel's Oracle Technology Team Core Members