Category Archives: R scripts

Monitor the database activity in real time with R

A quick post to let you know that I just finished a R script to monitor the database activity in real time. The “graph_real_time_db_activity.r” script (You can download it from this repository) basically takes a snapshot based on the v$system_event view then computes … Continue reading

Posted in R scripts | 1 Comment

Retrieve and visualize in real time wait events metrics with R

In one of my previous post  I provided a R script to retrieve and visualize wait events metrics from AWR. Now with this post I will provide a R script to retrieve and visualize the same metrics in real time. For that … Continue reading

Posted in R scripts | Leave a comment

Retrieve and visualize ASM Disk Group Usage per database with R

If you are using Oracle Enterprise Manager and ASM, then you may already be familiar with the following page that displays the Disk Group Usage per database for a particular Disk Group: And it is most likely that you don’t … Continue reading

Posted in R scripts | 1 Comment

Retrieve and visualize system statistics metrics from AWR with R

Into my last post I gave a way to Retrieve and visualize wait events metrics from AWR with R, now it’s time for the system statistics. So, for a particular system statistic, I’ll retrieve from the dba_hist_sysstat view: Its VALUE between 2 snaps … Continue reading

Posted in R scripts | 2 Comments

Retrieve and visualize wait events metrics from AWR with R

In this post I will provide a way to retrieve wait events metrics from AWR and to display graphically those metrics thanks to R over a period of time. Why R ?:  Because R is a powerful tool for statistical analysis … Continue reading

Posted in R scripts | 1 Comment