Title: RE: Oracle Analyze
**
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
:
arslist@ARSLIST.ORGSubject: 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: Acti
) [mailto:arslist@ARSLIST.ORG]
On Behalf Of Sanford, Claire
Sent: Monday, July 24, 2006 2:37
PM
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
: 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
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: arslist@ARSLIST.ORG
Subject: Re: Oracle Analyze
**
This is the thing the DBA did.
exec
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
/22/2006 12:11 AMTo: arslist@ARSLIST.ORG
Subject: Oracle AnalyzeMy 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.2Oracle 8.x I thinkClaire who has been working since 8:00am
) 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
8 matches
Mail list logo