Skip to Main Content

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!

Entries in v$session Without a Username?

570448May 4 2007 — edited May 4 2007
I noticed that I have some entries in v$session that don't contain a username.

If I:
SELECT count(*) from v$session where username = NULL;
I get zero, but when I do:
SELECT sid, username from v$session I can see that not all returned rows have a username?

Any idea what's going on there?

Thanks for your insight.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 1 2007
Added on May 4 2007
2 comments
833 views