Skip to main content

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.

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.