| 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
Lisa,
Your 'BECAUSE' is really a practical issue. I was also thinking same way
since this issue is being discussed for a week now. In practice, we must
know what tables are being changed or having activities like inserts/deletes
and make a script(s) for such tables to analyze in parallel from different
time specailly off-peak time and when those tables are not in use leaving
aside all such static tables or inactive tables reducing time to analyze and
CPU usage...
If you don't mind can I ask one question. What about your name change to
Mrs. Captain Morgan (and DBA)?. I think
Lisa Rutland(if I am not wrong) was more beautiful.....
MOHAMMAD RAFIQ
Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Date: Fri, 20 Jul 2001 08:50:29 -0800
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-L
> Subject: 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.
> 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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: rafiq9857_at_hotmail.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).Received on Fri Jul 20 2001 - 11:29:13 CDT
 |
 |