SQL & PL/SQL

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 not functioning properly

750518Feb 1 2010 — edited Feb 3 2010

Hi, when I tried to get list of all sessions starting with 'ARG' by using "Select USERNAME,OSUSER,MACHINE from V$session where username like 'ARG%'" in visual Basic program, although there are 3 open sessions that I'm sure (ARGE1, ARGE2 and ARGE4), It gives me result as only ARGE1, ARGE2 when I first run.

After a few seconds when I run it gives only ARGE4.
After a few seconds again when I run it either only gives ARGE1 and ARGE2 or ARGE4.

When I run it from PL/SQL listed only ARGE1 and ARGE2. But I'm sure ARGE4 is also active.

When I directly open the V$SESSION view by using ODBC linking on MSAccess, when I refresh the table, it randomly show either ARGE1 and ARGE2 or ARGE4 alone.

Could you help me please?

This post has been answered by Dom Brooks on Feb 2 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 3 2010

Added on Feb 1 2010

9 comments

1,484 views