Hello all,
Windows Server 2012 STD (physical server), Oracle DB 11g R2 Std.
Since 4 days ago, there are some cpu pick problems on the server (1 cpu 3
cores, 32 GB in RAM); they have been happening 2 or 3 times during the day
and take around 2-5 mins (the cpu picks to 100%, 99 of it used by the
Oracle Service).
I checked the threads running on it with Process Explorer, but there's no
specific query consuming it, but many consuming less than 5% of cpu; when
looking at the DB to find out the SQL text, I found that the query is
select 'x' from dual
AWR is disabled and no OEM console is configured (the DB was installed by a
vendor for Engineering team, I don't have so much information about this
specific setup).
Have you ever have had problems with " select 'x' from dual" query?, tried
to google some but haven't found something similar.
Thanks in advance.
Regards
David Ramírez Reyes
Profesión: Padre de Familia y DBA en mis ratos libres
Profession: Parent and DBA in my spare time