| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Long running Analyze
Ron,
I don't know what your goal is here so my suggestions may be incorrect. Why are you analyzing the entire db? Aren't there any static tables (and associated indexes) that you can omit from the analyze? It will be more analyze statements instead of just one to accomplish the task, but it may reduce the time you spend doing it. Maybe a full analyze once a week on the weekend or something will cut it along with daily less accurate analyzes for non-static tables.
How big is your host? Remember, analyze is pretty cpu intensive. Have you tried manually analyzing in parallel (analyze 3 tables at a time, or write three scripts to run simultaneously)?
If you are after the big question, WHY... I'm sorry. All I can say is BECAUSE.
hth
Lisa Koivu
Mrs. Captain Morgan (and DBA)
Ft. Lauderdale, FL, USA
-----Original Message-----
From: Smith, Ron L. [SMTP:rlsmith_at_kmg.com] Sent: Friday, July 20, 2001 10:22 AM To: Multiple recipients of list ORACLE-LSubject: Long running Analyze
I still don't have a good idea how long an Analyze compute should take on a
35gig database.
This is a 7.3.4 database with no activity other than the Analyze. The full
Analyze is taking
about 9 hours to complete. If I use estimate at 25% on the data and compute
on the indexes
it takes about 6 hours. Does this seem normal? Is there any way to speed
it up?
Thanks!
Ron
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L.Received on Fri Jul 20 2001 - 10:45:10 CDT
INET: rlsmith_at_kmg.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
 |
 |