contact us


Infrastructures Supported:

  • Any Unix or Linux operating system
  • Windows 2003 Server or Windows XP
  • Any logical volume manager
  • Any file system
  • Any storage subsystem
  • Any Oracle database version, including 7.8, 8i, 9i, 10g
  • SQL Server 2000 or 2005 database

New: TSP Service is now offered for MS SQL server databases.



Quick and effective trouble shooting. I have always gotten fast and accurate answers even to the most difficult and complex questions.

   – M.C., V.P. Consulting



The Certainty Group Full Value Guarantee Service Warranty.
Learn more.




The Certainty Group troubleshoots
the following custom and packaged enterprise applications running on top of Oracle databases:

  • Baan
  • Siebel
  • SAP
  • PeopleSoft
  • Oracle applications 10, 11, 11i
  • CRM
  • ERP
  • Data warehouses
  • Credit card processing
  • Payroll systems
  • Financials








 Performance Tuning  |  Configuration and Layout Service  |  Oracle Database Checklist


Oracle-related Issues

If Oracle-related Issues in your department are attracting the unwanted attention of upper management, The Certainty Group can help. With our Total System Performance software (TSP), we can perform a comprehensive analysis of the entire infrastructure and deliver a Recommendations Report that outlines the roadmap for tuning the system and optimizing performance so that your Oracle problems can be resolved.

The Certainty Group will help you to achieve Total System Performance (TSP) through its expert services:

  • On-site Consulting
  • Performance Analysis
  • Reliability Analysis
  • Recommendations Report    
  • Oracle License Consulting
  • Scripting/Automation Projects
  • Configuration and Layout Service
  • Server/Database/Storage Consolidation
  • ASM Usage/Maturity Recommendations
  • RAC Best Practice
  • Urgent Temporary DBA coverage
  • Forecasting Oracle Performance
  • Capacity Planning

We guarantee complete, accurate results within days for our exclusive TSP service


Performance Tuning:

Our exclusive Total System Performance (TSP) software will pinpoint the performance issues in a multi-vendor environment by collecting data throughout the entire infrastructure. Based on the data results and analysis, we will then provide an executive-level summary report, a detailed technical report with recommendations, and a comprehensive configuration report in order to inform the customer which areas need to be modified to bring the database system components into balance, ensuring reliability, scalability and peak performance.

Utilizing a single vendor to assess your Oracle performance issues will prove the most efficient and cost-effective solution by reducing the amount of time and money traditionally spent on consulting services. In addition to providing the performance tuning assessment and comprehensive recommendations report, TCG will also save you time and money by:

  • Reducing hardware requirements
  • Reducing software licensing fees
  • Eliminating S/W maintenance
  • Consolidating server/database storage
  • Configuring database layout
  • Eliminating business uncertainty and hidden costs

Back to top


Configuration and Layout Service:

Our configuration and layout service will give you accurate knowledge about the actual physical location of your database. We will analyze all relevant parameters and recommend the correct settings for best performance and reliable operation of your configuration, thus eliminating any uncertainties that can arise with new hardware and software environments.

Back to top


Oracle Database Optimization Checklist

Is your Oracle database performing with optimum speed and reliability or is your system impaired by bottlenecks and other operating problems? Consult this checklist of common problems to conduct a preliminary performance evaluation. Contact The Certainty Group for a thorough examination of your Oracle database or for a comprehensive assessment of your entire technology stack.

  1. Are all areas being checked at the same time to ensure consistent, comprehensive data?
  2. Are all areas being checked under Production Load? Some Monitors shut down under high load.
  3. Are duplicate control files located on the same physical disk?
  4. Is the DB_FILE_MULTIBLOCK_READ_COUNT init.ora set too low?
  5. Are Tables and Indexes in the same tablespace?
  6. Do tablespaces have large numbers of differing NEXT extent sizes?
  7. Are large or frequently loaded objects in the library cache not pinned?
  8. Is there Contention for the redo log buffer?
  9. Are rollback segments wrapping?
  10. Are near-duplicate SQL statements in shared pool?
  11. Are many SQL statements executed just once?
  12. Are operating system permissions set incorrectly?
  13. Do user accounts have easy-to-guess passwords?
  14. Are there excessively large numbers of blocks used for indirect extents for Veritas® VxFS filesystems?
  15. Are some SQL statements performing large numbers of logical reads to the buffer cache?
  16. Are some SQL statements performing large numbers of physical reads to the I/O subsystem?
  17. Are EMC® Symmetrix write pending track count limits being reached?

Back to top




© 2001-2008 The Certainty Group. All rights reserved.
Privacy Policy
32 Norwood Avenue
Suite 100
Newton, MA 02459