Oracle data buffer tuning scripts

Here, I'll discuss two scripts which I use often to check the oracle data buffer performance.

How to analyze v$active_session_history table to find the wait events in oracle

v$active_session_history is a important table to find the wait events inside oracle. In this article we'll show to use this table to find following important information.

How to identify the timing when database parameters exceeding predefined threshold value

The following powerful script can be used to identify the timing when the oracle database is exceeding some