<FONT face=Arial color=#0000ff
size=2>Analyze estimate with 10% sample, alternatively analyze compute during
off-hours, if possible. Most of my "million row" club tables get maintained only
on weekends, or in pre-scheduled intervals.
Gary WeberSenior DBACharles Jones, LLC609-530-1144,
ext 5529
<FONT face=Tahoma
size=2>-----Original Message-----From: root_at_fatcity.com
[mailto:root_at_fatcity.com]On Behalf Of Kevin LangeSent:
Tuesday, June 12, 2001 5:31 PMTo: Multiple recipients of list
ORACLE-LSubject: Forever running Analyze
Hi
folks;
We have an Analyze running that is taking forever. Here is the
setup:
<FONT face=Arial color=#0000ff
size=2> The table is about 250 bytes wide.
<FONT face=Arial color=#0000ff
size=2> The table is normally 100,000
rows
<FONT face=Arial color=#0000ff
size=2> The table has grown to over 4,000,000
rows.
<FONT face=Arial color=#0000ff
size=2> There is one index on 1 column.
<FONT face=Arial color=#0000ff
size=2> <FONT
face=Arial color=#0000ff size=2>We used the Compute Statistics
options
<FONT face=Arial color=#0000ff
size=2>
Does
anyone have any suggestions on how we can get this analyze to complete and still
generate worthwile statistics ??
<FONT face=Arial color=#0000ff
size=2>
<FONT face=Arial color=#0000ff
size=2>Thanks
<FONT face=Arial color=#0000ff
size=2>
<FONT face=Arial color=#0000ff
size=2>Kevin
Received on Tue Jun 12 2001 - 18:11:49 CDT
