| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle tuning sampling duration
The frequency of when a script should be run depends entirely on what the script does.. For instance - You may have a script that looks for space bound objects within your database (can't throw their next extent), depending on the number of objects within your database, this could be a REAL KILLER if run every 10 minutes! This kind of thing could be run quite happily twice in a day - once at lunch time (less user usage), and once at the end of the day. BUT, then again, you could have a database that grows stupidly quick..
Then you may have a script that collects SQL from your SQLArea for later tuning, if you ran this every 10 minutes, you could probably expect to be loosing information.. BUT, depending on the size of your SQLArea, this could again be quite a performance hit if issued every minute..
Typically a 10 minute interval would be good for monitoring sessions, I/O rates, hit ratios, locks/blocks etc.. What you really need to look at, is what the script is doing (and the performance hit), and then decide on the level of information you need on the results of these scripts.
Now, I deal with a performance monitoring tool, which does exactly this in background - Using rules (scripts) at user defined intervals (no this isn't a plug), and I can say from 3 years of experience selling this tool, that no one site has exactly the same set up for these rules! It all depends on the environment you are in.
I would certainly say design some kind of system that allows your scripts to all be run at an individual specified interval - whether it be every 4 hours or 5 minutes. Don't just say - "Right, here's my scripts, run them all every 10 minutes!" as this potentially could bring your system to its knees.
If you are in doubt about what a script does, or how often it should be run individually, why not post the script, and ask the gurus advice? I'll certainly give my input from my limited experience..
HTH & of course YMMV
Mark
-----Original Message-----
Darren
Sent: Wednesday, April 11, 2001 06:35
To: Multiple recipients of list ORACLE-L
When I took over the position of Oracle DBA I inherited a number of scripts,
including some
tuning scripts. Plus through this list and meta-link I have found a number
of resources about
tuning, What I am unsure about is when to capture the information required
for tuning decisions
The scripts I inherited are designed to run every 10 minutes. This produces
a large amount of
information. Which is okay, but is it over kill.
Scripts I have found on Metalink appear to be designed to run once a day.
Should I design a system that certain things are tracked every 10 min's, and
ones that are
collected at the end of the day, or capture information every 10 mins.
I should note that our databases are most active from 8:00 am to 5:00 pm.
Any tips, links, general advice would be appreciated.
Thanks
Darren
Darren Browett P.Eng This message was transmitted Systems Admin/DBA using 100% recycledelectrons
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Browett, Darren INET: dbrowett_at_city.coquitlam.bc.ca Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Thu Apr 12 2001 - 06:01:38 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: mark_at_cool-tools.co.uk Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
 |
 |