What may be happening is that the execution plan used ny Oracle to
fulfill your sql queries is different due to the stats gathered on you
tables.
This should help the performance of your apps, but if the
indexes/queries are poorly designed, the results of this may be
unpredictable. i.e., queries that once blindly used an index may opt
to no longer use an index.
We gather stats on our tables on a nightly basis.
Note that stats gathering is completely different than the reorg that
Jarl mentioned.
You can drop the stats collected by you dba by issueing the following:
EXEC DBMS_STATS.delete_schema_stats('ARADMIN');
Can you dba collect some stats on db usage to determine why the dba is
returning uery results slowly?
Axton Grams
On 7/24/06, Rick Cook <[EMAIL PROTECTED]> wrote:
**
Claire,
What happens if you drop the indexes for one of your forms, then re-add
them? Can people submit and modify? If not, look at the transaction log
space or tempDb to see if it's full.
Rick
________________________________
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Sanford, Claire
Sent: Monday, July 24, 2006 11:37 AM
To: [email protected]
Subject: Re: Oracle Analyze
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Sanford, Claire
Sent: Monday, July 24, 2006 11:37 AM
To: [email protected]
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:[EMAIL PROTECTED] On Behalf Of Rick Cook
Sent: Saturday, July 22, 2006 1:36 PM
To: [email protected]
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: [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___ __20060125_______________________This
posting was submitted with HTML in it___
__20060125_______________________This posting was submitted
with HTML in it___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
