Oracle Database Discussions

Announcement

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!

How can a session have an ACTIVE status with a WAITING state

fcjunicAug 16 2010 — edited Aug 17 2010

Hi all,

I would like to know the difference between status and state of a session ?
The documentation says :

for status ACTIVE : Session currently executing SQL
for state WAITING : The session is currently waiting...

How can a session execute a SQL statement and be waiting at the same time ?

Regards,

fcjunic.

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 14 2010

Added on Aug 16 2010

#general-database-discussions

5 comments

4,416 views