Though a database may be operational and performing effectively, there are often ways to improve this performance. True diagnosis requires an historical evaluation and a look at all of the vital signs as a whole (CPU utilization, memory utilization, paging frequency, backups, file system space utilization, etc.). The same holds true for the database. Key factors are analyzed generating concrete performance recommendations.

easyDBA offers a comprehensive analysis and a tuning of a full set of DBMS performance aspects: DB settings, queries, OS, middleware and storage. Our DB tuning services include:

  • Heaviest SQL statement identification and tuning
  • Resource contention identification
  • Sotred procedures and Oracle PL/SQL tuning services
  • RAC tuning
  • Batch run analysis
  • Assessment of applications
  • Recommendations of new features