Hi,
If there are more than enough space allocated for a database or table and are not being used, will it affect the performance of a database? Thanks!
Printable View
Hi,
If there are more than enough space allocated for a database or table and are not being used, will it affect the performance of a database? Thanks!
On startup will be a little slower (talking about datafiles)
, if you have table whith remainnig extents (unused) -by delete... you performans will be (depends on the number of extents) not good. So try to eliminate the extents (by exp - imp) of your table.
You can deallocate all the free unused extents at the end of the table with the ALTER TABLE sql command.
Se your Oracle sql reference guide
Bye