Performance & Tuning in Oracle Database
Change AWR snapshot Retention period and Interval in Oracle: In this article we will discuss about how to Change AWR snapshot Retention period and Interval in Oracle. About AWR Report: Oracle MMON background process collect the AWR statistics and generate the snapshot based on retention period, which violates the threshold metric. You can enable this … Read more
How to find and kill a session in Oracle: During this article we are going to discuss the way to find and kill Oracle sessions. Many times we are facing issue in Database Level, then we would to check and find out sessions details, how much there are active/inactive/killed sessions and might killed some sessions. … Read more
How to install, configure, and use Stats pack in Oracle. During this article, we’ll see the way to install, configure, and use Statspack in Oracle Database. Here we will do this activity in Oracle 19c Database. What is Statspack in Oracle? The collected Data are analyzed using the Statspack reports, which has an instance health … Read more
