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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

12c - How to Manage TEMP tablespace

Beauty_and_dBestJul 6 2020 — edited Jul 16 2020

12c

OL7

Hi ALL,

We always encounter ORA-01652 in our TEMP tablespace.

How do you manage TEMP?

How do we size TEMP?

Do we set it autoextend on unlimited maxsize?

Do we create more than one TEMP?

What is the maximum number of TEMP recommended to be created in each database?

Please help...

Kind regards,

This post has been answered by Jonathan Lewis on Jul 9 2020

Jump to Answer

Added on Jul 6 2020

#general-database-discussions

22 comments

2,145 views