Oracle wait interface(OWI) is a performance tracking methodology that focuses on process bottlenecks, which are better known as wait events. It is a collection of a few dynamic performance views and an extended SQL trace file and provides statistics for wait events to tell you how many times and how long the session waited for an event to complete.
Using Oracle wait interface, DBAs can precisely identify the major bottlenecks in the system based on time and resolve performance issues by applying the appropriate solution that reduces or bypasses the bottlenecks.
meda Changed status to publish 19/10/2022