bedbmsguru

blocking session 모니터링

SELECT
          datname,
          usename,
          application_name,
          now()-backend_start AS "Session duration",
          pid,
          wait_event,
          wait_event_type,
          query
        FROM
          pg_stat_activity
        WHERE
          state='active'
        AND wait_event IS NOT NULL;

SELECT /*+ RULE */ D.JOB, V.SID, V.SERIAL#, STATUS, LOG_USER USERNAME, WHAT, DECODE(TRUNC(SYSDATE - LOGON_TIME), 0, NULL, TRUNC(SYSDATE - LOGON_TIME) || ' Days' || ' + ') || TO_CHAR(TO_DATE(TRUNC(MOD(SYSDATE-LOGON_TIME,1) * 86400), 'SSSSS'), 'HH24:MI:SS') RUNNING, D.FAILURES, 'alter system kill session ' || '''' || V.SID || ', ' || V.SERIAL# || '''' || ' immediate;' KILL_SQL FROM DBA_JOBS_RUNNING D, V$SESSION V, DBA_JOBS J WHERE V.SID = D.SID AND D.JOB = J.JOB;

http://www.runningoracle.com/product_info.php?products_id=34

SQL Server Management Studio에 플러그인 방식으로 설치된다.

가독성이 좋구만..

http://architectshack.com/PoorMansTSqlFormatter.ashx#License__Redistribution_17