This discussion is archived
1 2 Previous Next 16 Replies Latest reply: Mar 18, 2013 7:34 AM by Nicolas.Gasparotto RSS

Process Usage is at 70% in normal status

David_Pasternak Newbie
Currently Being Moderated
Hi @ everybody,

I'm using Nagios for monitoring and have the Plugin "check_oracle_health" running on an Oracle 11gR2 instance, that report, there are 70% of Process usage by 10 Tablespaces at every time. But its OK!

The plugin seems to use that SQL Selection:
SELECT current_utilization/limit_value*100 FROM v$resource_limit WHERE resource_name LIKE '%processes%'
Is that too much? How can i find that out at my self? How can i optimise that?

Thanks a lot and best regards!

David

Edited by: David_Pasternak on 18.03.2013 03:52

Edited by: David_Pasternak on 18.03.2013 03:53
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points