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

Thread: Space allocation question

  1. #1
    Join Date
    Mar 2000
    Location
    Atlanta, GA,USA
    Posts
    155
    We are doing 650Gb database migration from 8.0.5 over to 9iR2 using 2 different boxes.

    The source 8.0.5 database has 4Kb block size and a particular table partition allocates 2.2 million blocks for 10 million records. The pctfree for the partition is set to 5 and the table has one numeric column, three varchars (1 or 2 characters each) and four RAW(2000) columns.
    Destination 9.2 database has 16Kb block tablespaces and the same partition allocates 1.4 million blocks with pctfree 1.
    Looks like with larger blocks table allocates 3 times more space than in 4K block database.

    The question is where I am losing space?

    Sergey Popov
    National Processing Company, LLC
    Louisville, KY


  2. #2
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    Some question:
    Which character set is using in old database and whitch
    in new?
    Then:
    Did u analize both tables (new/old) and ca u post result of
    analize?

  3. #3
    Join Date
    Mar 2000
    Location
    Atlanta, GA,USA
    Posts
    155
    Originally posted by Shestakov
    Some question:
    Which character set is using in old database and whitch
    in new?
    Then:
    Did u analize both tables (new/old) and ca u post result of
    analize?
    8.0.5 database has US7ASCII char set and 9.2 has WE2MSWIN1252.
    Analyze table is in progress

    Thanks,
    Sergey.

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