xoxomos
asked on
Resize Tablespace Hangs
About five hours ago i went through OEM to resize a datafile in the TEMP tablespace which had zero data. TEMP is not the default temporary tablespace. Looking at OEM all i see is that pink 'other' blocked sessions 1 root blockers 1. What needs to be done to have Oracle actually complete the resize this century?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Found 43 inactive sessions still hanging on to TEMP. Policy dictated I could not kill them as recommended in the blog so I just waited for the application to be shut down for weekly cold backup. As soon as application shut down, tablespace resize completed.
ASKER
11.2.02
At this time not highly active, but yes it's active.
Yes it's archivelog mode. Plenty room in archive_dest_nn.
Datafile currently 20G. I am trying to resize DOWN to 2G.