hi all
how we can see the queries which is currently in the sga ie shared pool, buffercahe etc.
Printable View
hi all
how we can see the queries which is currently in the sga ie shared pool, buffercahe etc.
select
username users, sql_text, Executions, loads, users_executing,
sharable_mem, persistent_mem
from
sys.v_$sqlarea a, dba_users b