column start_dt format a20
column start_dt1 format a20
set lines 120 pages 300
select to_char(start_date, ‘DD-MON-RRRR:HH24:MI’) start_dt, user_cpu, system_cpu, idle_cpu, wait_cpu
from STATS$VMSTAT2
where start_date > trunc(sysdate)
order by start_date;
select to_char(measured_date, ‘DD-MON-RRRR:HH24:MI’) start_dt, total_users, Active_users from STATS$TOTALUSERS
where measured_date > trunc(sysdate)
order by measured_date;
select to_char(start_date, ‘DD-MON-RRRR:HH24:MI’) start_dt1, system_sessions, active_users, inactive_users,
dedicated_servers, user_sessions, transactions
from STATS$USERSESSION
where start_date > trunc(sysdate)
order by start_date;