All geek questions in one place

How to implement Oracle user profiles for practical use?

Oracle 10g has profiles that allow you to limit various resources. Here are some links for clarity - orafaq.com , Oracle Documentation . I am particularly interested in limiting CPU_PER_CALL, LOGICAL_READS_PER_CALLand COMPOSITE_LIMITin order to prevent a poorly formed statement from disrupting performance for every other session.

My problem is that I don’t know what values ​​to use for these parameters, which will allow you to perform typical lengthy, resource-intensive operations, while preventing really bad ones. I understand that the values ​​will vary depending on the hardware, tolerance levels and requests, so I'm more interested in the method that you need to follow in order to determine which values ​​are best.

+3
source share
1 answer

. , - , - , (, , , , , , - ) CPU_PER_CALL parallelism. , , 30 , , CPU_PER_CALL CPU 30 (, 100 % , 30- ).

, ( ) AWR/statspack ( //, ) , CPU I/O. (.. , + 30% ).

, , , - , , . - , , 30% 6 . , , , - .

, , , . , . , , 30 , , , , .

+4

Source: https://habr.com/ru/post/1708659/

More articles:


All Articles