Is that too much? How can i find that out at my self? How can i optimise that?
SELECT current_utilization/limit_value*100 FROM v$resource_limit WHERE resource_name LIKE '%processes%'
David_Pasternak wrote:I can't say it's normal it's depend on Hardware and how you configured your Database .
Thanks for answering. But I don't know anything about using and interpreting AWR and it is not licensed at the instance.
But I try to find out, if a process usage by 70% is normal?
David_Pasternak wrote:Using Statspack . That's a free option and wouldn't be very far behind from AWR. See the documentation to install, configure and use it.
Of course, cause i want to have that awesome featute. But now i've to look to clean that problem. But how without AWR?