• 링크
• 명령어모음
• 오라클 맥스 세션수 알아보기
• SELECT name, value 
    FROM v$parameter
   WHERE name = 'sessions'
• 오라클 버전 알아보기
• select * from v$version where banner like 'Oracle%';
• #결과
  Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
• 테이블 사용 정보 (테이블 수정 내역등)
• SELECT * FROM USER_TAB_MODIFICATIONS
• select TABLE_NAME,MONITORING from DBA_tables; 에서 MONITORING에 YES인 것들만 모니터링 됨
• http://blog.daum.net/phj6013/9200977
• http://radiocom.kunsan.ac.kr/lecture/oracle/dictionary/user_tab_modifications.html
• 옵티마이저에 의해서 테이블이 분석된 이후에 현재 사용자의 테이블에 적용된 모든 변경 내용을 포함한다.
• 세션 메모리 사용량
• http://kr.forums.oracle.com/forums/thread.jspa?threadID=464020

• ttitle '1. Current pga, uga session memory'
  
  select a.sid, a.username, substr(a.program, 1, 25) as pgm, a.terminal,
  max(decode(c.name, 'session pga memory', trunc(value/1000)||'K', 0)) pga,
  max(decode(c.name, 'session uga memory', trunc(value/1000)||'K', 0)) uga
  from v$session a, v$sesstat b, v$statname c
  where a.sid = b.sid
  and b.statistic# = c.statistic#
  and c.name like 'session%'
  group by a.sid, a.username, substr(a.program, 1, 25), a.terminal;
  ttitle '2. Sum of current pga, uga session memory'
  
  select 'Current PGA, UGA session memory SUM:' as sum,
  sum(decode(c.name, 'session pga memory', trunc(value/1000),0))||'K' pga_sum,
  sum(decode(c.name, 'session uga memory', trunc(value/1000),0))||'K' uga_sum
  from v$session a, v$sesstat b, v$statname c
  where a.sid = b.sid
  and b.statistic# = c.statistic#
  and c.name like 'session%';
  ttitle '3. Max(peak) pga, pga session memory'
  
  select a.sid, a.username, substr(a.program, 1, 25) as pgm, a.terminal,
  max(decode(c.name, 'session pga memory max', trunc(value/1000)||'K', 0)) pga_max,
  max(decode(c.name, 'session uga memory max', trunc(value/1000)||'K', 0)) uga_max
  from v$session a, v$sesstat b, v$statname c
  where a.sid = b.sid
  and b.statistic# = c.statistic#
  and c.name like 'session%'
  group by a.sid, a.username, substr(a.program, 1, 25), a.terminal;
  ttitle '4. Sum of max(peak) pga, uga session memory'
  
  select 'Max(peak) PGA, UGA session memory SUM:' as sum,
  sum(decode(c.name, 'session pga memory max', trunc(value/1000), 0))||'K' pga_m_sum,
  sum(decode(c.name, 'session uga memory max', trunc(value/1000), 0))||'K' uga_m_sum
  from v$session a, v$sesstat b, v$statname c
  where a.sid = b.sid
  and b.statistic# = c.statistic#
  and c.name like 'session%';

#TEMP TABLESPACE 재생성