Re: High CPU utilization

On Sun, 2024-03-17 at 14:55 +0530, Krishnaprasad Yadav wrote:
> Dear All ,
>
> Thanks for your response , 
> Currently  we have non-cdb architecture and there are independent DB
> instances running on a single server , hence it becomes difficult to
> identify which one is  causing the high CPU Usage . 
>
> Please suggest the same .
>
> Regards,
> Krishna
>

Krishna, this is an OS problem, not an Oracle one. You have several groups of processes/threads (depending on the OS) and you need to compare them with respect to resource usage. Generally speaking, that is done through OS auditing. Depending on your OS, you may need to use either open source auditing package or a commercial one. You may wait for Oracle 27c, which will incorporate artificial intelligence and the mind reading abilities, and be able to write your queries for you. Oracle is developing a version for HAL 9000.

https://www.youtube.com/watch?v=UwCFY6pmaYY

That was an example of ORA-600.

-- 
Mladen Gogala
Database SME
https://dbwhisperer.wordpress.com


--
http://www.freelists.org/webpage/oracle-l