Spotlight uses 100% CPU
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
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:
# 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