Skip to main content


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.

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.