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...
performance
ORA-04031: unable to allocate bytes of shared memory (“large pool”,”unknown object”,”large pool”,”CTWR dba buffer”)
PROBLEM: Application Team is running lot of DML activities on the database and suddenly database became slow with lot of blocking sessions with “Block Change Tracking Buffer” event. Also, ...
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...