-- system의 time model
select stat_name,value/ (
select value
from v$sys_time_model
where stat_name = 'DB time'
) * 100 "사용률"
from v$sys_time_model
order by value desc
/
-- user의 sid 찾기
select s.sid, s.serial#,u.username
from v$session s, dba_users u
where s.user#=u.user_id
and u.username = 'HR'
/
-- session의 time model
select sid, value from v$sess_time_model
where stat_name='DB time'
/
-- 이하 클래스 분석 -> stat,event분석 할 것.
select stat_name,value/ (
select value
from v$sys_time_model
where stat_name = 'DB time'
) * 100 "사용률"
from v$sys_time_model
order by value desc
/
-- user의 sid 찾기
select s.sid, s.serial#,u.username
from v$session s, dba_users u
where s.user#=u.user_id
and u.username = 'HR'
/
-- session의 time model
select sid, value from v$sess_time_model
where stat_name='DB time'
/
-- 이하 클래스 분석 -> stat,event분석 할 것.
