Return
-
Title
Various Spotlight queries are showing up as being in the top 10 activities on a very busy Oracle database -
Description
Oracle Enterprise Manager shows that various Spotlight queries are in the top 10 activities on a very busy Oracle database. -
Cause
This issue might be seen if monitoring the same Oracle database with multiple Spotlight clients. -
Resolution
1. Change the data refresh rates for all the queries
a. Go to 'View | Options'b. Under 'Data collection' click on 'Data refresh rates'c. By default it is 15 seconds in foreground and 60 seconds background so please change it to 30 seconds foreground and 120 seconds background2. The Flash Usage and Latch query takes most of the execution time (about 70%). We can limited the execution interval for these two queries to 10 minutes with the attached support.dat_Minrefresh file.
a. Download the attached file support.dat_Minrefreshb. Go to C:\Program Files (x86)\Dell\Spotlight on Oracle 10.3\Plug-ins\SoOc. Paste support.dat_Minrefresh into itd. Rename 'support.dat_Minrefresh' to 'support.dat'e. Restart SpotlightNote: If you have more than one Spotlight Client, you need to do the above steps for all the Spotlight clients.
-
Attachments