How to monitor Oracle contention

From: Eriovaldo Andrietta <ecandrietta_at_gmail.com>
Date: Tue, 21 Nov 2017 22:42:49 -0200
Message-ID: <CAJdDhaOSt9HRW-APcMFma44GmQHA4gd5713-VOBTtfO0jFvc7Q_at_mail.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

Received on Wed Nov 22 2017 - 01:42:49 CET

This message: [ Message body ]
Next message: Franky Weber Faust: "Re: How to monitor Oracle contention"
Previous message: dba Wilson: "Re: SQL Tuning Tool"
Next in thread: Franky Weber Faust: "Re: How to monitor Oracle contention"
Reply: Franky Weber Faust: "Re: How to monitor Oracle contention"
Reply: dba Wilson: "Re: How to monitor Oracle contention"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message