Voltar
-
Título
Spotlight query high CPU cost -
Descrição
Spotlight uses 100% CPU
-
Causa
Queries taking too long to run may cause performance issues. This is due to setting optimizer_mode=first_rows for all queries using v$parameter
-
Resolução
Setting optimizer_mode=first_rows, causes all queries using v$parameter to take a long time. The solution is to add an ALTER SESSION to the spotlight.ora file.
So your spotlight.ora file looks like this now:
# SPOTLIGHT.ORA
#
# This file is designed to issue "alter session" statements.
# It is only read ONCE, when the program starts up , and is applied to all instances
#
# Lines start with a '#' are comment.
#alter session set events '10046 trace name context forever, level 1'
alter session set optimizer_mode=all_rows
# End of spotlight.ora file -
ID do defeito
CR0219653