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!

Optimal size for TEMP tablespace tempfiles

BaffyJun 14 2009 — edited Jun 29 2009

Hi all,

I've rumaged through Oracle documentation on the above topic but can't find the answer I'm seeking:

How do you determine the optimal size for your tempfiles? Are there rules to guide one in this area? For example for a 50G database, how do you determine if it's 2G, 3G or 4G that's best for the database? What about a 500G database?

Anwers will be appreciated.

Regards

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 27 2009

Added on Jun 14 2009

#general-database-discussions

10 comments

7,825 views