Símbolo de Antón Campos
Antón Campos
Freelance Oracle DBA Galego Español English

Performance Tuning

Oracle performance tuning

  • Instance and Database performance analysis.
  • Operating system and storage performance analysis.
  • Batch performance analysis.
  • Backup control.
  • Database parametering.
  • Identification and solving of bottlenecks.
  • Identification of heavy processes.
  • Recommendations and implementation of new configurations to improve performance.

SQL performance tuning

In case of performance problems, Oracle recommends dealing with SQL tuning first, even before tackling instance, BD or system tuning. This is due to the fact that redesigning transactions or queries can in itself bring about great improvement in global performance. Consequently, this is a key point in global performance analysis.

We must take into account that an Oracle Database is a transactional system. Transactions are the minimal units of data manipulation. We must therefore concentrate on each of them individually in order to optimize them, always starting from the heaviest ones and bearing in mind the transactional load of the system (transactions per minute required) and the database object locks.

On the other hand, there are the SQL queries, for which we must take into account the selected optimization, the indexes and the structure of the query itself.

Bear in mind that the engine of the Oracle database is optimized to best deal with declarative languages (SQL), rather than procedural languages (PL ou C).

For more information, please contact Antón Campos stating your query.

CC License Xosé Antón Campos Silva
Rúa Eugenio Carré Aldao 19 baixo
15007 A Coruña
+34 617 453 167
 Valid HTML 4.01 Transitional Valid CSS!