AWR

How to find free memory of Server and other OS Metrics in Oracle

In this post we will see some of the important OS metrics in oracle. At the start of AWR report you will find Host Name, Platform, CPUs, Cores, Sockets, Memory. Do you know where you can find these details in

What is DB Time?

What is DB Time? DB Time is the total time spent by the all user processes which are actively working or actively waiting in the database calls. It includes the CPU Time, IO Wait time and non-idle time. It tells

AWR DBTime script

DB Time is very important metric in AWR report. When analyzing an AWR report the, DB Time is the first thing which i see as it tells us how much activity database was performing in that time interval. Suppose we have to perform analysis on