15. Diagnosing and Recovering from TEMPFILE I/O Issues
Temporary tablespaces are often the bane of Oracle database technology: Oracle DBAs rarely think about them as a possible vector for database performance issues, but when they do cause poor performance, they tend to stick out in a crowd. This chapter briefly reviews the history of temporary tablespace features. It then discusses the benefits and drawbacks of using temporary tablespace to improve database performance. Finally, it looks at some of the symptoms of application performance when a temporary tablespace has been identified as the root cause of the performance problem.
Overview of Temporary Tablespaces
Temporary tablespaces have been available for the Oracle databases since Oracle ...
Get Oracle Database Problem Solving and Troubleshooting Handbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
