Oracle temporary tablespace performance
0
votes
1
answer
138
views
I'm looking for ways to improve my database performance for heavy analytical queries and found that my temp tablespace has 1M extents (default for uniform tablespace). With my usual temp tablespace usage far above 1GB per query (top queries with heavy joins/sorts/groups can consume up to 100 GB of temp tablespace) 1M extents looks too low for me. Is it worth increasing extent size for performance?
Asked by Andy DB Analyst
(110 rep)
May 30, 2024, 03:03 PM
Last activity: May 30, 2024, 06:25 PM
Last activity: May 30, 2024, 06:25 PM