Best Practices To Configure Database Temp Table Space
(Doc ID 2545912.1)
Last updated on MARCH 09, 2023
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 |