Why is Oracle loading the CPU at 100%?

B

batalish2020-12-22 13:37:39

linux

batalish, 2020-12-22 13:37:39

Good day! There is a server working on RH and base on it. Such a problem, periodically the base loads percents. the server is 100 percent and only oracle goes to top, other services and processes stop responding. Where can I see the logs?
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

Reply

Answer the question

In order to leave comments, you need to log in

3 answer(s)

K

ky0, 2020-12-22
@ky0

These are the questions you should ask the Oracle DBA, not the Toaster. Because after the logs you will ask about profiling, query optimization, etc.

I

idShura, 2020-12-22
@idShura

See ASH report (Active Session History) and AWR report (Automatic Workload Repository) for the period in which the problem occurs. It would also be nice to specify the database version and so on.

O

Oleg Volkov, 2020-12-22
@voleg4u

Orakl by and large single-threaded basis. One session - one processor. Therefore, sometimes specifically THIS session asks SUCH a request that loads this entire processor by 100. Why? As mentioned above - optimization, etc.