I recently noticed there was a trace file created by SMON that says:
SMON: following errors trapped and ignored:
ORA-01575: timeout waiting for space management resource
At the time I was resizing an tablespace. What is the cause of this error?
Printable View
I recently noticed there was a trace file created by SMON that says:
SMON: following errors trapped and ignored:
ORA-01575: timeout waiting for space management resource
At the time I was resizing an tablespace. What is the cause of this error?
Hi,
One of the segments in that tablespace must be trying to allocate a new extent. As the resizing locks the tablespace till the operation is complete the extent allocation must have timed out.
Baliga
Thank you!