Temporary segment cleanup in Oracle

By | April 29th, 2012|DBA Miscellaneous, Oracle DBA|

  When does SMON cleanup temporary segments?        o. Typically a user process allocates a temporary segment (multiple          extents) and then dies before cleaning them up, or the user process          receives an error causing the statement to fail. SMON is posted to do          the cleanup. SMON also might [...]