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!

Why username is null V$session ?

716427Sep 16 2010 — edited Sep 16 2010

Hi

I am working on oracle XE installed on XP . Connected to DB using the SQL * plus . When I query the following.

Select username from V$session ;

Output :

Username
SYS

15 rows selected .

Why it shows the null values for user name . I have opened only once SQL * plus . No other session or connection to DB.

can anyone please suggest?

This post has been answered by Pierre Forstmann on Sep 16 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 14 2010

Added on Sep 16 2010

#general-database-discussions

2 comments

8,722 views