ORA-13605 sql access advisor, when execute SQL Access Advisor en Oracle

Once again he repeats the story, a PathSet installed with the idea of solving problems and new ones appear (this time without document).

This time it was to install the PatchSet on the version The fact is that now when trying to run the SQL Access Advisor, the task is not created but an error in the alert.


Continue reading

Enabling MySQL slow query log or without indexes

In a production environment, it is recommended enabled the slow query log for analyzing occasionally.

Activation is performed in the parameter file used (usually my.cnf) adding within the section


log_slow_queries = /var/log/mysql/mysql-slow.log
long_query_time = 10

Continue reading