tuning - Root Fan

How to Get the sql_id of a Query in Oracle

You might need to get the sql_id of a Query in Oracle to troubleshoot some performance problem or just to check some stats.

This is the simplest way to do it.

If you are having problems with your Apache installation, it might be caused by a bad configuration.

You might have a high consumption of CPU as I had.

First of all, you need to know that your Apache config files are located in here

cat /etc/apache2/mods-available/mpm_prefork.conf