ORA-04031: unable to allocate bytes of shared memory (“large pool”,”unknown object”,”large pool”,”CTWR dba buffer”)
PRO...
performance
How to find current running sqls in oracle
Use below script to get the current running sql details....
Get explain plans of a sql query from AWR using DBMS_XPLAN.DISPLAY_AWR
By analyzing the awr report ...