Only time I had to shrink manually is to resize my datafiles, normally if you set optimal Oracle will do it automatically, anyway during transaction intensive times roll back segment shouldnt be shrink and extended all the time to avoid perfomance issues




Reply With Quote