Re: How to monitor Oracle contention

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_at_gmail.com>:

> ​​
> 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
>
>
>

--
http://www.freelists.org/webpage/oracle-l