For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.
Hello
I have a PDB database that shows all these waits:
However I don't have any blocks sessions:
How do I find out what is wrong?
Usually used to show only green.
4 Active sessions use CPU, run AWR for that period and check out what's is running (if you licensed for performance pack).
Oracle database waits are a normal part of how the database operates—they occur when a session or process needs to pause because it's waiting for something, like a resource (CPU, disk, locks, etc.) to become available. Often, these waits are perfectly normal, especially for idle sessions (like SQL*Net message from client, where the database is simply waiting for the user to send the next command). However, if waits start happening too frequently or take too long, it could indicate a bottleneck or inefficiency in your database.
To tackle this issue, you can check wait events using Oracle diagnostic tools like AWR (Automatic Workload Repository) or v$system_event, where you’ll get a detailed view of what’s causing these waits. With this information, you can easily pinpoint and resolve performance issues by optimizing queries, adjusting indexes, improving resource allocation (CPU, memory, or storage), or addressing application-level problems like excessive commits.
So, while waits themselves aren't errors, they’re a friendly signal from your database saying, "Hey, something is slowing me down here!" Understanding and addressing these waits is essential for keeping your database running smoothly and efficiently.
Thank you both for your answer. I am not a real dba. I have some difficult in interpreting the AWR report. I don't know how to find the cause of the wait errors.
I would suggest to read documentation or talk to DBA.
In general oracle process usually in two states: idle and wait. When an wait is not an error is normal state of an database process. There is many types of waits, some of the waits need attention another not.
There is tons of reading about it. In my opinion well worth to spend time on it.
