Performance Troubleshooting Series : external link
1. Identifying Problematic Sessions or Queries (Preface)
1. Database is/was slow.
2. Our Session/Query is/was slow.
2.Identifying Problematic Sessions or Queries (Method 1)
Method 1. Session Wait Event Approach:-
we will try to identify from the problematic session
what its waiting for /why its waiting /what can be done to resolve the problem.
1.Troubleshooting Instance Memory Structures (SGA + PGA) Usage
In the previous series we have seen how to troubleshoot IO, CPU and Database TimeSpent/Consumed,
Previous parts in the series we have covered, DB Load Profile, DB Load Profile2, Time Model, IO Performance.
Understanding Database CPU – Consumers – Waiters – Average Active Sessions
1. Understanding your Oracle Database Load - Part 1
2.Understanding your database load from Metrics – Part 2
Understanding Database CPU – Consumers – Waiters – Average Active Sessions
Understanding I/O Wait Performance of Oracle Database
After Looking at identifying Database Load in previous posts (Post 1,Post 2) and seeing where the database time spending much (Post 3). Its time to check out how I/O is performance how much average millseconds for each type of I/O wait happening.Here we are going to discuss about two cases,
1. Case 1: Current I/O Waits and its average wait in milliseconds
2. Historical I/O Waits and its average wait in milliseconds
