V$session does not return any rows but GV$session does
AminuMay 20 2013 — edited May 20 2013Hi everyone,
I have a problem on my Oracle Database (Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 running on Solaris 5.10). This morning I realized that when I query v$session, I dont get any rows:
SQL> select from v$session;*+
no rows selected+
But when I query gv$session, it returns some rows:
SQL> select count() from gv$session;*+
COUNT()*+
----------+
*152*
This is a single instance database and I am surprised at this behaviour. I am testing an application on this database and the application cannot run until rows can be returned from v$session.
Please help.