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% recycled
electrons
Information and Communications Technology.
City of Coquitlam
P:(604) 927 - 3614
E:[EMAIL PROTECTED]
----------------------------------------------------------------------------
-------------------------------------------------
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Browett, Darren
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mark Leith
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
