ACTIVE
Short Description
The process being looked at is in an active state in the database.
Detailed Description​
This is the normal state from V$SESSION for a session which is performing a query in the database.
How to reduce this wait​
In order to reduce this figure, you have to make your database do less work, either by reducing the number of queries or making the queries more efficient.
Additional Links​
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.