| 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: Should we stop analyzing?
-----Original Message-----
From: Jared.Still@radisys.com [mailto:Jared.Still@radisys.com]
Sent: Tuesday, December 30, 2003 5:29 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Should we stop analyzing?
If just 2, then from a users perspective, it would seem most appropriate
to have statistics collected during the day, when people are banging
away on the OLTP stuff.
But then, might that play havoc with the batch jobs?
[Shrek]no might about it boss man, trust me. been there done that, got the T-shirt, the sweat shirt AND the leather jacket.;-) we eventually went to two sets of init files after i had a long fight with damagement.;-)
How about 2 sets of statistics. Import the OLTP stats in the morning for
the users, and the BATCH stats at night for the batch jobs.
[Shrek]NOW he tells me.;-) could i have done that in 7.3 and 8i?;-)
--Bill "Shrek" Thater ORACLE DBA"I'm going to work my ticket if I can..." -- Gilwell song------------------------------------------------------------------------The value of a program is proportional to the weight of its output.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: William.Thater_at_carrier.utc.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).Received on Wed Dec 31 2003 - 07:19:25 CST
 |
 |