Why is Oracle loading the CPU at 100%?

Question

linux

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

Answer 1

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.

Answer 2

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.

Answer 3

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.