Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What are wait classes?

April 26, 2017classes wait

0

Posted

What are wait classes?

1 Answer

0

Posted

A wait class is a logical collection of a set of wait events. Wait classes are extremely useful in finding which component or resource of the database is having performance problems. In Oracle 10g, there are 12 wait classes namely, Administrative, Application, Cluster, Commit,Concurrency, Configuration, Idle, Network, Other, Scheduler, System I/O, and User I/O. For any given wait event, you can find the wait classes it belongs to from the V$EVENT_NAME view using the following SQL.