Hi DBA Experts,
Can any one please help me to understand which section of AWR report we must see for understanding SQLs which were consuming high memory during a particular period of time ?
you can find information about SQL in the SQL STATISTICS section of AWR report.
SQL ordered by Sharable Memory
however, this information has never been of any value to me. Perhaps other people find it useful.
don't look in AWR. Look in ASH -- it can tell you about PGA usage by specific SQL statements.
ASH basics | Oracle Diagnostician
SQL order by information in SQL Stats doesnt have any information regarding Memory.
Can you please specific which area in ASH report ? Our DB is 10.2.0.4 release and we need to find out sql's which consumed high memory during particular period of time ..
I've given you a link -- did you even look at it? The query you need is number 12.