Performance Tuning  |  Configuration and Layout Service  |  Oracle Database Checklist

 

SERVICES

How Can the Certainty Group Help You?

Business solutions depend upon the performance and reliability of the systems that support them. The Certainty Group can optimize your technology and your business by providing comprehensive total-system configuration analysis, performance tuning and auditing of systems that utilize Oracle databases. 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

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?
    
    The Certainty Group is an independent Oracle® database performance and reliability consultancy specializing in solving complex problems in multi-vendor, mission-critical systems for business software applications. Our exclusive Total System Performance (TSP) toolset expedites the analysis of performance and reliability for the entire technology stack an Oracle database depends on—delivering guaranteed, measurable results in days, not weeks or months.