Re: Oracle Analyze

Sat, 22 Jul 2006 11:37:03 -0700

**
I was thinking the same thing - the Analyze was like a Checkpoint, updating the statistics.  That would constitute a pretty significant re-org of the DB, especially if it had been a while since the last time it was run.

Rick
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank Caruso
Sent: Saturday, July 22, 2006 10:07 AM
To: [email protected]
Subject: Re: Oracle Analyze

** Ensure that you have appropriate indexes for the long running  queries. Running statistics should be a good thing. Maybe they had not been run in a long time and now your current indexes do not support your bigger queries. Also, fund out exactly what the DBA did. I can remember having problems when stats were run on each table in its entirety. There is a way ton run stats on just a small percentage of the rows in each table which may work better.



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: [email protected]
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



--
Frank Caruso
Specific Integration, Inc.
Senior Remedy Engineer
www.specificintegration.com
703-376-1249 __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___

Reply via email to