Re: Oracle Analyze

[Sanford, Claire]

**

This is the thing the DBA did.

exec dbms_stats.gather_schema_stats('ARADMIN')

Right now we are dead in the water. Remedy Tech Support is working on it too...

The AR System was up and running at the time and that command has never been run on this database.

If I stop and start the ARS Server service, people can do searches for a little while, then they get time outs.

Any ideas?

Claire "10 hours of sleep in 72 hours" Sanford

---

From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook
Sent: Saturday, July 22, 2006 1:36 PM
To: arslist@ARSLIST.ORG
Subject: Re: Oracle Analyze

**

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: arslist@ARSLIST.ORG
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: 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___ __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___