Anyway to Determine How Much TEMP Space is Needed for Gathering Table Stats
HI Folks
I am running into a situation where when I gather table stats I run out of TEMP Space
Questions:
1. Other than creating a bigger TEMP space, is there a way to get around this issue ?
2. Is there a way to determine how much TEMP space I need for gathering the stats on this table ?
Any advise would be appreciated
Thanks
Jim
================
Background Info:
RDBMS: 10.2.0.22
TEMP Space: 8GB
Execute: dbms_stats.gather_table_stats
Error: unable to extend temp segment by 128 in tablespace TEMP
Table: DAuditNew
Rows: 231778612
Index1 Distinct Keys: 8384825
Index2 Distinct Keys: 58928861
Index3 Distinct Keys: 1346
Index4 Distinct Keys: 220251538