无法在 Oracle DB 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production 中查询“job_queue_processes”
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/29646459/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Can't query 'job_queue_processes in Oracle DB 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
提问by Nu?ito de la Calzada
I want to query the value of job_queue_processes:
我想查询job_queue_processes的值：
select value from v$parameter where name='job_queue_processes';
But I can't, I get a
但我不能，我得到一个
`ORA-00942: table or view does not exist`
Querying user jobs is fine, as well:
查询用户作业也很好：
select * from user_jobs
Querying version is fine, as well:
查询版本也很好：
select * from v$version where rownum<2;
SYS.dba_jobs_running & SYS.dba_jobs are not working either (ORA-00942: table or view does not exist)
SYS.dba_jobs_running 和 SYS.dba_jobs 也不工作（ORA-00942：表或视图不存在）
select * from SYS.dba_jobs_running;
select * from SYS.dba_jobs;
回答by anudeepks
SYS@research 15-APR-15> grant select on v_$parameter to sample;
Grant succeeded.
SAMPLE@research 15-APR-15> select value from v$parameter where name='job_queue_processes';
VALUE
---------------------------------------------------------------------------------------------
1000
