SELECT                                                   -- TOP IO SQL --
         a.parsing_user_id, a.executions, a.buffer_gets, a.disk_reads,
         a.direct_writes, a.address, a.hash_value, a.sql_id, '||', a.*
    FROM v$sqlarea a
   WHERE a.disk_reads > 100000
ORDER BY a.disk_reads DESC
/
SELECT                                            -- TOP GETS(LIO) SQL --
         a.parsing_user_id, a.executions, a.loads,
         TRUNC (a.cpu_time / 1000000) cpu_time_s,
         TRUNC (a.elapsed_time / 1000000) elapsed_time, a.buffer_gets,
         a.disk_reads, a.direct_writes, a.address, a.hash_value,
         a.sql_id, '||', a.*
    FROM v$sqlarea a
   WHERE a.buffer_gets > 1000000
ORDER BY a.buffer_gets DESC
/
SELECT                                                   -- PGA MEMORY --
       TRUNC (SUM (p.pga_used_mem) / 1024 / 1024) pga_used_mem,
       TRUNC (SUM (p.pga_alloc_mem) / 1024 / 1024) pga_alloc_mem,
       TRUNC (SUM (p.pga_freeable_mem) / 1024 / 1024) pga_freeable_mem,
       TRUNC (SUM (p.pga_max_mem) / 1024 / 1024) pga_max_mem,

       SUM (CASE
               WHEN p.pga_used_mem > 32 * 1024 * 1024
                  THEN 1
               ELSE 0
            END
           ) usedpga32m,
       SUM (CASE
               WHEN p.pga_used_mem > 64 * 1024 * 1024
                  THEN 1
               ELSE 0
            END
           ) usedpga64m,
       SUM (CASE
               WHEN p.pga_used_mem > 128 * 1024 * 1024
                  THEN 1
               ELSE 0
            END
           ) usedpga128m,
       SUM (CASE
               WHEN p.pga_used_mem > 256 * 1024 * 1024
                  THEN 1
               ELSE 0
            END
           ) usedpga256m,
       SUM (CASE
               WHEN p.pga_used_mem > 512 * 1024 * 1024
                  THEN 1
               ELSE 0
            END
           ) usedpga512m,
       SUM (CASE
               WHEN p.pga_used_mem > 1024 * 1024 * 1024
                  THEN 1
               ELSE 0
            END
           ) usedpga1g
  FROM v$process p
/
SELECT                                   -- TEMP USAGE MORE THAN 100 MB--
         b.*, '||', a.status,
         NUMTODSINTERVAL (a.last_call_et, 'second') vremya, a.user#,
         a.lockwait, a.osuser, a.machine, a.*,
            'alter system kill session '''
         || a.SID
         || ','
         || a.serial#
         || ''';' forkillsql
    FROM v$session a,
         (SELECT   u.username, u.session_addr, u.TABLESPACE,
                   SUM (u.blocks) usaege_blocks,
                   TRUNC (SUM (u.blocks) * 8192 / 1024 / 1024) usage_mb
              FROM v$sort_usage u
          GROUP BY u.username, u.session_addr, u.TABLESPACE) b
   WHERE b.session_addr = a.saddr AND b.usage_mb > 100
ORDER BY 4 DESC
/

SELECT -- SESSIONS_STAT --
 vs.TYPE,
 vs.status,
 COUNT(1) sessions,
 (SELECT COUNT(1) FROM v$session t WHERE t.TYPE = 'USER') total_user,
 (SELECT COUNT(DISTINCT t.username) FROM v$session t WHERE t.TYPE = 'USER') total_user_dist,
 
 SUM(DECODE(vs.blocking_session, NULL, 0, 1)) blocked,
 SUM(DECODE(vs.taddr, NULL, 0, 1)) transactions,
 SUM(CASE
       WHEN vs.seconds_in_wait > 3 * 60 * 60
            AND vs.schemaname IN ('MYSCHEMA')       
        THEN
        1
       ELSE
        0
     END) inactive_more_3hour,
 SUM(DECODE(vs.event#,
            165,
            1,
            119,
            1,
            166,
            1,
            118,
            1,
            120,
            1,
            117,
            1,
            116,
            1,
            163,
            1,
            164,
            1,
            0)) io,
 SUM(DECODE(vs.event#, 59, 1, 0)) latch_buff_chains,
 SUM(DECODE(vs.wait_class, 'Idle', 0, 1)) non_idle,
 SUM(DECODE(vs.wait_class, 'Concurrency', 1, 0)) concurrency,
 SUM(DECODE(vs.wait_class, 'User I/O', 1, 0)) user_io,
 (SELECT COUNT(1) FROM v$session t) total_all
  FROM v$session vs
 GROUP BY vs.TYPE, vs.status
 ORDER BY vs.TYPE DESC, vs.status /