My database size was 1TB and its full export size is 300GB.
After imported db to new environment, db size reduced to 700GB. What could be reason for this ?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
There could be many reasons. But generally, it may be due to:
Check the size of your
temp tablespace and the
redo tablespace. The reduction may come from there.
This is exactly what I would expect of any good RDBMS.
A database that has been used for a long amount of time will fragment. Your efficiency of the fragmented database is 70%, which I would say is pretty good.
When importing the data into a fresh database, there will be no fragmentation, but after you have deleted and inserted lots of rows, you will see fragmentation will hit you again.