Current location - Health Preservation Learning Network - Slimming men and women - Oracle table space is too large, what are the optimization methods?
Oracle table space is too large, what are the optimization methods?
Give you the following advice:

(1) If the data in the tablespace is not full, you can consider shrinking the tablespace.

(2) If the tablespace data is full, consider building multiple tablespace files.

(3) From the business point of view, whether we can consider stripping some data and storing it in the historical database.

(4) From the business point of view, is the data in the largest table in this table space necessary and useful? Whether you can back up and clean up some useless data.

(5) If it is a reduction tablespace, the reduction tablespace can be shrunk.

(6) If it is a temporary tablespace, the original tablespace file can be deleted and rebuilt.