Re: Oracle Analyze

2006-07-31 Thread McKenzie, James J C-E LCMC HQISEC/L3
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

Re: Oracle Analyze

2006-07-24 Thread Sanford, Claire
: 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

Re: Oracle Analyze

2006-07-24 Thread Adam D Pederson
) [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

Re: Oracle Analyze

2006-07-24 Thread Benter, David W CTR NSWC PC
: 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

Re: Oracle Analyze

2006-07-24 Thread Axton
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

Oracle Analyze

2006-07-22 Thread Sanford, Claire
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

Re: Oracle Analyze

2006-07-22 Thread Frank Caruso
/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

Re: Oracle Analyze

2006-07-22 Thread Jarl Grøneng
) 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