Re: ORA-00942: table or view does not exist for v$session.

From: <>
Date: Fri, 12 Feb 2016 01:57:32 -0800 (PST)
Message-ID: <>

Hi Eugene,

while i am running "SELECT COUNT(*) cnt,status FROM v$session GROUP BY status" it is working fine, fetching the records

but same thing iam using in a procedure like below  FOR i IN

    ( SELECT COUNT(*) cnt,status FROM SYS.v$session GROUP BY status     )
but here i am getting the Same error Table does not Exist

can you please reply on this plese

and is there any possiblities to use this query resultset in my procedure? Received on Fri Feb 12 2016 - 10:57:32 CET

Original text of this message