Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Gather stats job failing with temp space issue

AbbDBAFeb 17 2010 — edited Feb 17 2010
OS - HP UX B.11.23 U ia64
Oracle - 10.2.0.3
Database Size - 490 G
Schema size - 364 G

declare
begin
DBMS_STATS.GATHER_SCHEMA_STATS
(ownname=>'ABC',
estimate_percent => 20,
METHOD_OPT=>'FOR ALL COLUMNS SIZE AUTO',
DEGREE=> DBMS_STATS.default_degree,
CASCADE=> TRUE,
granularity=>'ALL');
end;
/

We are using the above job, but the job is failing with temp space issue. The temp tablespace size has been increased to a whopping from 30G to 70G. Schema consist of Partitioned tables and partitioned indexes.
But still we are facing this issue. Please advice.

Thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 17 2010
Added on Feb 17 2010
#general-database-discussions
6 comments
2,571 views