"ASH (Active Session History)"의 두 판 사이의 차이
DB CAFE
(새 문서: == ACTIVE SESSION HISTORY TOP 10 == select * from ( select SQL_ID , sum(decode(session_state,'ON CPU',1,0)) as CPU, sum(decode(session_state,'WAITING',1,0)) - sum(decode(se...) |
|||
1번째 줄: | 1번째 줄: | ||
== ACTIVE SESSION HISTORY TOP 10 == | == ACTIVE SESSION HISTORY TOP 10 == | ||
+ | <source lang=sql> | ||
select * from ( | select * from ( | ||
select | select | ||
13번째 줄: | 14번째 줄: | ||
) | ) | ||
where rownum <11 | where rownum <11 | ||
+ | </source? |
2018년 10월 22일 (월) 19:47 판
thumb_up 추천메뉴 바로가기
- DBA { Oracle DBA 명령어 > DBA 초급 과정 > DBA 고급 과정 }
- 튜닝 { 오라클 튜닝 목록 }
- 모델링 { 데이터 모델링 가이드 }
ACTIVE SESSION HISTORY TOP 10[편집]
<source lang=sql> select * from ( select SQL_ID , sum(decode(session_state,'ON CPU',1,0)) as CPU, sum(decode(session_state,'WAITING',1,0)) - sum(decode(session_state,'WAITING', decode(wait_class, 'User I/O',1,0),0)) as WAIT, sum(decode(session_state,'WAITING', decode(wait_class, 'User I/O',1,0),0)) as IO, sum(decode(session_state,'ON CPU',1,1)) as TOTAL from v$active_session_history where SQL_ID is not NULL group by sql_id order by sum(decode(session_state,'ON CPU',1,1)) desc ) where rownum <11 </source?