SELECT owner, table_name, num_rows, last_analyzed
FROM dba_tab_statistics
where OWNER not in ('SYS','SYSTEM')
and LAST_ANALYZED is not null
and NUM_ROWS !='0'
order by 3 desc;
SELECT c.owner, c.object_name, c.object_type, b.SID, b.serial#, b.status,
b.osuser, b.machine
FROM v$locked_object a, v$session b, dba_objects c
WHERE b.SID = a.session_id AND a.object_id = c.object_id
AND Object_name like ('%IBY%');
SELECT 'ALTER SYSTEM KILL SESSION '''||sid||','||serial#||''' IMMEDIATE;' FROM v$session WHERE
last_call_et > 14400 -- 7200 segundos = 2 horas
AND status = 'INACTIVE' and USERNAME='PRODUCCION';
#ENTÉRATE | 🚀 Conoce la historia de Jonathan, un joven ingeniero aeronáutico que busca ser parte de la misión UNTY en 2026 y podría alcanzar su sueño gracias a Insulini.
Entérate de todo en el siguiente vídeo ▶️