Top 10 de los queries que estan en memoria.
Este query muestra los 10 queries mas pesados en memoria.... esta piola porque podemos evaluarlo para ver ocupacion de SGA que nos eta matando al equipo o en su defecto la propia base.
aca se los dejo..
EXITOS !!!
-- -----------------------------------------------------------------------------------
-- Author : Fabian Crea - Cristian Mendoza
-- Last Modified: 15/12/2007
-- -----------------------------------------------------------------------------------
SET LINESIZE 500
SET PAGESIZE 1000
SET VERIFY OFF
SELECT *
FROM (SELECT Substr(a.sql_text,1,50) sql_text,
Trunc(a.disk_reads/Decode(a.executions,0,1,a.executions)) reads_per_execution,
a.buffer_gets,
a.disk_reads,
a.executions,
a.sorts,
a.address
FROM v$sqlarea a
ORDER BY 2 DESC)
WHERE rownum <= &&1;
SET PAGESIZE 14
aca se los dejo..
EXITOS !!!
-- -----------------------------------------------------------------------------------
-- Author : Fabian Crea - Cristian Mendoza
-- Last Modified: 15/12/2007
-- -----------------------------------------------------------------------------------
SET LINESIZE 500
SET PAGESIZE 1000
SET VERIFY OFF
SELECT *
FROM (SELECT Substr(a.sql_text,1,50) sql_text,
Trunc(a.disk_reads/Decode(a.executions,0,1,a.executions)) reads_per_execution,
a.buffer_gets,
a.disk_reads,
a.executions,
a.sorts,
a.address
FROM v$sqlarea a
ORDER BY 2 DESC)
WHERE rownum <= &&1;
SET PAGESIZE 14
Comentarios