Sadan's Oracle dba Blog

  Run the undo advisory script to verify the undo tablespace recommendation Script - Check Current Undo Configuration and Advise Recommended Setup (Doc ID 1579035.1) SET SERVEROUTPUT ON SET LINES 600 ALTER SESSION SET NLS_DATE_FORMAT = 'DD/MM/YYYY HH24:MI:SS'; DECLARE     v_analyse_start_time    DATE := SYSDATE - 7;     v_analyse_end_time      DATE := SYSDATE;     v_cur_dt                DATE;     v_undo_info_ret         BOOLEAN;     v_cur_undo_mb           NUMBER;     v_undo_tbs_name         VARCHAR2(100);     v_undo_tbs_size         NUMBER;     v_undo_autoext          BOOLEAN;     v_undo_retention        NUMBER(5);     v_undo_guarantee        BOOLEAN;...

  What are the queries that are running?  select sesion.sid,        sesion.username,        optimizer_mode,        hash_value,        address,        cpu_time,        elapsed_time,         sql_text    from v$sqlarea sqlarea, v$session sesion  where sesion.sql_hash_value = sqlarea.hash_value    and sesion.sql_address    = sqlarea.address    and sesion.username is not null  / Get the rows fetched, if there is difference it means processing is happening  select b.name, a.value vlu from v$sesstat a, v$statname b where a.statistic# = b.statistic#  and sid =&sid and a.value != 0 and b.name like '%row%'  /  Get the sql_hash_value  select sql_hash_value from v$session where sid='&sid';  SQL> select sql_hash_value from v$session where...