performance

Generate performance report in postgres using pg_profile

If you have worked on oracle, then you must of aware of AWR report, which is used to generate workload performance report of the database for a specific duration. But in postgres there is no inbuilt f...

How to find current running sqls in oracle

Use below script to get the current running sql details.   select sesion.sid, sesion.username, optimizer_mode, hash_value, address, cpu_time, elapsed_time, sql_text from v$sqlarea sqlarea, v$sess...

Get explain plans of a sql query from AWR using DBMS_XPLAN.DISPLAY_AWR

By analyzing the awr report ,you found that there was some issue with a particular sql_id, and you want to get the explain plans associated with that sql_id. We can get the explains using dbms_xplan.d...