defragmenting objects
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: defragmenting objects

Hybrid View

  1. #1
    Join Date
    Oct 2000
    Posts
    90
    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?


    thanks,
    dorothy

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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
    Posts
    90
    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