Search code examples
sqloracleoracle11g

Cannot find table v$parameter in Oracle

I want to get the number of sessions in Oracle using the SQL query:

SELECT value FROM v$parameter WHERE name = 'sessions'

But I get this error:

Error starting at line 1 in command:
SELECT value FROM v$parameter WHERE name = 'sessions'
Error at Command Line:1 Column:18
Error report:
SQL Error: ORA-00942: table or view does not exist
00942. 00000 -  "table or view does not exist"
*Cause:    
*Action:

Maybe the Oracle user that I use is not privileged?

Solution

  • Generally the better approach is to use a procedure and grant the necessary privileges to this procedure. However if you want use SQL directly, you can grant SELECT_CATALOG_ROLE or SELECT ANY DICTIONARY to the user.