Re: Oracle Analyze

[Frank Caruso]

** 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: 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

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