Wow! Jarl, That article even made sense to me!
The DBA added statistics to the tables and they were the cause of most of the problems. He removed the stats and now the system is running ok or close to normal again. I'm going to sleep now! Claire -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jarl Grøneng Sent: Saturday, July 22, 2006 1:52 PM To: arslist@ARSLIST.ORG Subject: Re: Oracle Analyze This article explains what likely happend: http://asktom.oracle.com/pls/ask/f?p=4950:8:7550689886422531643::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:6601312252730 -- Jarl On 7/22/06, Rick Cook <[EMAIL PROTECTED]> wrote: > Ask your DBA what the Analyze function did. I wonder if it reset some > indexes or page sizes or something. > > > ____________________________________________________________________________________ > > Rick Cook * Remedy Approved Consultant * Denali Advanced Integration * (253) > 278-4112 > > ________________________________ > > From: Action Request System discussion list(ARSList) on behalf of Sanford, > Claire > Sent: Sat 7/22/2006 12:11 AM > To: arslist@ARSLIST.ORG > Subject: Oracle Analyze > > > > > My DBA performed an Oracle Analyze on the remedy database. Since then we > have had weird query timeout issues. > > Is doing this to a Remedy database a bad thing? > > > > ARS 4.5.2 > Oracle 8.x I think > > > > > Claire "who has been working since 8:00am" Sanford > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org > > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org