Databases
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