Analysing Temp usage on 11GR2 when Temp space is not released

(Coskan Gundogar) We had an interesting issue on our 3 node cluster about the temp usage. One night one of the critical batch operation which never used high temp suddenly hit “ORA-01652: unable to extend temp segment by string in tablespace string tips”. Once we check the system we saw some “inacti

Read More - Register for Free Membership