Claire:
Shoot your DBA for running this on an active database.
This command takes a long time and basically locks up your database, It should NEVER be run on a running database.
James McKenzie
________________________________
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Sanford, Claire
Sent: Monday, July 24, 2006 11:37 AM
To: arslist@ARSLIST.ORG
Subject: Re: Oracle Analyze
**
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:arslist@ARSLIST.ORG] 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:arslist@ARSLIST.ORG] 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 <mailto: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 <http://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___
