Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

how do you montior current value of processes param..

K.C. Chan
Trusted Contributor

how do you montior current value of processes param..

All,
the parameter "processes" from v$paramter, how do you monitor what actual usage of this value? Is there a dictionary table or view I could query to get the current usage of this value? Thanks.
Reputation of a thousand years can be determined by the conduct of an hour
3 REPLIES
spex
Honored Contributor

Re: how do you montior current value of processes param..

select value
from v$parameter
where name='processes';
K.C. Chan
Trusted Contributor

Re: how do you montior current value of processes param..

I think this will only returned what the value is set to. I want to know how much it is currently using. Thanks.
Reputation of a thousand years can be determined by the conduct of an hour
K.C. Chan
Trusted Contributor

Re: how do you montior current value of processes param..

figured it out.
Reputation of a thousand years can be determined by the conduct of an hour