My Oracle Support Banner

Best Practices To Configure Database Temp Table Space (Doc ID 2545912.1)

Last updated on JANUARY 17, 2020

Applies to:

Oracle SOA Suite - Version 12.2.1.3.0 to 12.2.1.3.0 [Release 12c]
Information in this document applies to any platform.

Goal

Your DBAs are recommending to change oracle database temp spaces (created during SOA installation using rcu).

1. What are the best practices to configure/setup SOA/OSB database Temp table space?

2. Can changing the TEMP table spaces cause any other issues with current SOA/OSB product installations?

Your initial research found the information below and you are requesting help on this:

Some of Oracle performance tuning guide also suggests using multiple temp tablespaces to get better performance. Some SOA queries can generate a large amount of disk sorts that require high amounts of temporary space. Therefore, the use of multiple temporary tablespaces and tablespace groups is recommended to meet these requirements and assure optimal performance.
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.