在Oracle中找不到表v $ parameter [英] Cannot find table v$parameter in Oracle

问题描述

我想使用SQL查询获取Oracle中的会话数:

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

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

但是我得到这个错误:

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:

也许我使用的Oracle用户没有特权?

Maybe the Oracle user that I use is not privileged?

推荐答案

通常，更好的方法是使用一个过程，并为此过程授予必要的特权.但是，如果要直接使用SQL，则可以向用户授予SELECT_CATALOG_ROLE或SELECT ANY DICTIONARY.

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.

这篇关于在Oracle中找不到表v $ parameter的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！