smon clean up undo & temp
Hi ,
Growing sizes of UNDO and TEMP tablespaces , and Not releasing the memory by oracle is most common problem
I read somewhere that SMON perform cleanup of undo and temp.
When will SMON perform cleanup ,if yes ,will it shrink the size of ?
Is there a way to get SMON to do so by DBA?
Edited by: udayjampani on Nov 9, 2011 2:14 PM