DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2000
    Will defragmenting segments in the tablespaces increase the FSFI of the tablespaces too? If you export all the tables and import them in order to defragment the objects in the tablespace, will that also inrease the FSFI of the tablespace?


  2. #2
    Join Date
    Jun 2000
    Madrid, Spain
    if you export a tablespace contents then import into another tablespace (or recreating the old tablespace) you will get FSFI 100
    If you do export at table level you probably improve a bit FSFI depending on your extents sizing, if the size is uniform you would perfectly fit the import into empty extents and reuse them. However bear in mind that FSFI is based at tablespace level.

  3. #3
    Join Date
    Oct 2000
    Do I need to export and import all the tables in the given tablespace at the same time to get FSFI to be 100 or near 100. Or I can choose to do the export and import of say five tables, then later on in the day export and import another five tables, and so on?
    Or it does not really matter?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.