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!

v$session , status "inactive" is really inactive

2670775May 31 2016 — edited Jun 3 2016

I am doing a test. I open two sqlplus terminal and one check v$session where sid = 'sid of the second sqlplus'

I run something for example select * from dba_tables, on sqlplus terminal one I keep checking the status from v$session and it always show "INACTIVE"

but the result is still not fully returned in the 2nd sqlplus terminal..

why is this case ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 1 2016

Added on May 31 2016

#general-database-discussions

13 comments

4,724 views