Search the web
Sign In
New User? Sign Up
spotonoracle · Spotlight on Oracle Users
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Want to share photos of your group with the world? Add a group photo to Flickr.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
Lightening Spotlight's load on your database   Message List  
Reply | Forward Message #4 of 25 |
Spotlight is designed to place no more than 2% load on your database.
If you want to reduce the server load even further there are a few
techniques you can use.

First and foremost, you can reduce the frequency with which Spotlight
queries the database. By default, Spotlight refreshes itself every 15
seconds for data that is currently being displayed (foreground refresh
rate), and every 60 seconds for data that is to be collected but is not
currently being displayed (background refresh rate).

You can change this via a Spotlight Option. From the View menu, select
Options, Spotlight Console, Data Collection tab, and modify the refresh
rates.

Alternatively, you can change the Overhead Settings by clicking the
Flag icon on the toolbar. If you move the slider to "Lower Impact"
setting, several of the more expensive Spotlight queries will not run;
and also some queries will only be executed when the associated
drilldown is being displayed.




Wed Apr 9, 2008 7:34 am

billjacobs2323
Offline Offline
Send Email Send Email

Forward
Message #4 of 25 |
Expand Messages Author Sort by Date

Spotlight is designed to place no more than 2% load on your database. If you want to reduce the server load even further there are a few techniques you can...
billjacobs2323
Offline Send Email
Apr 9, 2008
7:34 am
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help