CODEWITHSUNDEEP
oracle-databaseoracle11g
Nuñito Calzada
Nuñito Calzada

Reputation: 1948

Can't query 'job_queue_processes in Oracle DB 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

I want to query the value of 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)

select * from SYS.dba_jobs_running;
select * from SYS.dba_jobs;

Upvotes: 2

Views: 18547

Answers (1)

anudeepks
anudeepks

Reputation: 1132

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

Upvotes: 6

Related Questions