Database Administration (MOSC)

MOSC Banner

Anyway to Determine How Much TEMP Space is Needed for Gathering Table Stats

edited May 14, 2014 10:40AM in Database Administration (MOSC) 5 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center