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

Thread: Space allocated for database

  1. 11-30-2000, 06:33 AM #1
    mooks
    mooks is offline Senior Member
    Join Date
    Jan 2000
    Posts
    387

    Talking

    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!
    Reply With Quote Reply With Quote
  2. 11-30-2000, 07:17 AM #2
    aracnid
    aracnid is offline Member
    Join Date
    Apr 2000
    Location
    roma
    Posts
    131
    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.
    Reply With Quote Reply With Quote
  3. 11-30-2000, 10:16 AM #3
    oradbadmin
    oradbadmin is offline Junior Member
    Join Date
    Nov 2000
    Posts
    71
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width