addressed few more review comments.
  important logical error corrected: if tablespace get full then same variable
  was updated to reflect status of sys and tmp tablespace.