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
– Pavel, Commented Jul 30, 2014 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
– neshkeev, Commented Jul 30, 2014 at 12:33
Read This Fine Manual. You can't work with oracle only by taking advices from StackOverflow — neshkeev
– neshkeev, Commented Jul 30, 2014 at 13:01

Frank Schmitt · Accepted Answer · 2014-07-30 12:15:09Z

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, 2014 at 12:15

Frank Schmitt

30.5k13 gold badges79 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

neshkeev Over a year ago

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.

Collectives™ on Stack Overflow

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

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related