What causes temp tablespace to be full and generates ORA-01652 error
0
votes
1
answer
5274
views
I would like to understand in what sort of situations or what issues could cause TEMP tablespace to run out of space.
- Is it too much sorting occur on TEMP?
- How do I identify such issue from AWR?
- And how usually it can be resolved?
My Oracle Database instance is running on version 18c.
I am a DBA who mainly manages the operational side of the DB. I don't do much development / code writing. I would like to understand more, so I could provide some advice to the developers.
Asked by Jason Oon
(13 rep)
Aug 18, 2022, 06:28 AM
Last activity: Apr 23, 2025, 07:04 AM
Last activity: Apr 23, 2025, 07:04 AM