dbms_stats

From: venkat Rama <techsqlca_at_yahoo.com>
Date: Wed, 16 Jul 2003 07:44:02 -0700 (PDT)
Message-Id: <25937.338039@fatcity.com>

--0-1494275816-1058366642=:8102
Content-Type: text/plain; charset=us-ascii

Hi Friends,

Iam trying to run dbms_stats package, Iam keep getting out of memory error!! I tried to increase ulimit -d unlimited by giving more process memory!! I also got end of channel error too. Iam running with options 20% estimate with cascade true. I have 8174 db version on aix5.1 with baan4c front end. My idea is to run stats every week against 100 main tables that changes frequently!! I tried with gather stale too!! But my proble with out memory error(ora-4030) persists!!

tia
venkat.

Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month! --0-1494275816-1058366642=:8102
Content-Type: text/html; charset=us-ascii

<DIV>Hi Friends,</DIV>
<DIV> </DIV>
<DIV>Iam trying to run dbms_stats package, Iam keep getting out of memory error!! I tried to increase ulimit -d unlimited by giving more process memory!! I also got end of channel error too. Iam running with options 20% estimate with cascade true. I have 8174 db version on aix5.1 with baan4c front end. My idea is to run stats every week against 100 main tables that changes frequently!! I tried with gather stale too!! But my proble with out memory error(ora-4030) persists!!</DIV>
<DIV> </DIV>
<DIV>tia</DIV>
<DIV>venkat.</DIV><p><hr SIZE=1>

Do you Yahoo!?<br>
<a href="http://pa.yahoo.com/*http://rd.yahoo.com/evt=1207/*http://promo.yahoo.com/sbc/">SBC Yahoo! DSL</a> - Now only $29.95 per month!
--0-1494275816-1058366642=:8102-- Received on Wed Jul 16 2003 - 09:44:02 CDT