Hi Eriovaldo,
ASH is a good way to monitor the real time waits. You need to turn on
tuning pack and then query v$active_session_history.
Regards,
Wil
2017-11-22 11:42 GMT+11:00 Eriovaldo Andrietta <ecandrietta@xxxxxxxxx>:
Hi,
I am using Oracle 12c R1 and I need to monitor the database contention.
I don´t have access to the EM tool, so I must to use queries.
I saw some views that can show informations about instances, like :
-- For active sessions
v$system_event;
v$system_wait_class;
v$session_wait;
V$SESSION_EVENT;
-- To explore queries
dba_hist_snapshot (to select snap_id and use in the where of others)
dba_hist_sqltext
dba_hist_sqlstat
-- To explore history events
dba_hist_system_event;
dba_hist_active_sess_history;
Dba_Hist_Sysstat;
Are there another good views to explore events history in order to monitor
events below?
disk (I/O)
cpu
memory
table lock
network (for RAC contention)
I know that I can ask to run the AWR report , but I would like to get a
set of queries to use daily.
Regards
Eriovaldo