Oracle Database Discussions

Hi,

Oracle:9.2.0
OS: Sun Solaris
2 node clustered

I want to check how many sessions are connected to database
along with user information.
my question here, oracle displays 32 sessions without user name...


SQL> select username, count(*) from gv$session group by username ;

USERNAME COUNT(*)
------------------------------ ----------
aaa 3
bbb 1000
32

SQL> select inst_id, username, count(*) from gv$session group by inst_id, username ;

INST_ID USERNAME COUNT(*)
---------- ------------------------------ ----------
1 16
1 aaa 1
1 bbb 556
2 16
2 aaa 2
2 bbb 452

SQL> select inst_id, count(*) from gv$session group by inst_id;

INST_ID COUNT(*)
---------- ----------
1 570
2 468


Thanks,