Dear m.uracz,
Thanks for replying back and sharing the link
I already gone through this link and setup maintenance jobs in UC4. Tried run it, everything ran smoothly. But could not find any decrease in size of the database or oracle datafile. Still the size remains same. Today morning again ran shrink on tablespace gained 1GB free space.
My UC4 database size is around 77GB
Not sure if anything I missed out to clear properly.
Thanks,
Pothi