Sample Header Ad - 728x90

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