Skip to content

ORA-1652: unable to extend temp segment by 128 in tablespace TEMP01

Problem:

TEMP tablespace was getting filled when running sql statement.

i increased the temp table size from 25g, 32g, 64 gb. in all cases it throws error.

Solution:

I ran sql tuning advisor on sql and it gave recommendation of profile, index and gather stats.

i created profile, index and gather stats. it did magic sql completed under 5 seconds and did not throw any error.

No comments yet

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: