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

Question

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?

What do you mean by "user/schema" ? I have connected sqlcommand line to oracle using "connect username/password" — Pavel, Jul 30 '14 at 12:15
to perform DML/DDL/DCL statements you have to be connected to oracle as some user, for oracle user == schema, what user/schema did you use to connect to the DB? — neshkeev, Jul 30 '14 at 12:33
Read This Fine Manual. You can't work with oracle only by taking advices from StackOverflow — neshkeev, Jul 30 '14 at 13:01

score 3 · Accepted Answer · answered Jul 30 '14 at 12:15

3

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.

answered Jul 30 '14 at 12:15

Frank Schmitt

30,195
12
73
107

Thanks, man. I didn't know about the v_$parameter view. I tried to grant select on the v$parameter view but this view is a dynamic view. – neshkeev Jul 30 '14 at 12:35

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

1 Answers1