CODEWITHSUNDEEP
sqloracle-database
Pavel
Pavel

Reputation: 138

Why "SQL> show parameter processes" command is not working?

I am using oracle 10g express edition. I ran the command in sql command line and it says -- "ORA-00942: table or view does not exist"

PS: Trying to access and increase the number of processes. Cause I am facing this problem -- How to solve ORA-12516 error?

Upvotes: 0

Views: 6590

Answers (1)

Frank Schmitt
Frank Schmitt

Reputation: 30775

You're probably running this command as a non-privileged user. show parameter is just a fancy wrapper for select ... from v$parameter. You need SELECT privileges on this view:

grant select on v_$parameter to <username>;

(please note the _ in the view name - you cannot directly grant privileges on v$ views, you have to grant privileges on the underlying objects instead).

Of course, the simplest approach is to run show parameter as a DBA user.

Upvotes: 3

Related Questions