Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2002
    Posts
    1

    Unanswered: Table Definition

    Oracle version 8.1.7
    OS : Sun Solaris 8

    I have to create a table. The average length of a record is 100 bytes and the average growth of that table is 12.000.000 records each day.
    All old records are deleted every 2 days then the table must keep 24.000.000 online.
    The DB Block Size is 8192.
    I know that the pctincrease should be zero, the initial and next extent shoul have the same size which is ??

    What are the best values for the storage clause (initial, next, pctfree, pctused) ?

    Thanks a lot,

    Eric

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Table Definition

    I don't know the answers to your specific questions, but this sounds like a prime candidate for using partitions if ever I saw one! Then you won't be deleting 24 million records every other day, you will just drop the oldest partition and add a new one. Each partition will need to be sized for 24 million records (2.4GB if my maths is correct).

  3. #3
    Join Date
    Oct 2002
    Location
    greenwich.ct.us
    Posts
    279
    Yes, a partitioned table would make your life much easier. (and your math is wrong. 100 bytes * 12,000,000 = 1171875K)


    As far as INITIAL and NEXT, I would look at how many devices you can spread your data on. If you have 10 devices, I would make the INITIAL and NEXT so I had about 10 extents on each device.
    Last edited by marist89; 11-22-02 at 17:04.

  4. #4
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    Originally posted by marist89
    Yes, a partitioned table would make your life much easier. (and your math is wrong. 100 bytes * 12,000,000 = 1171875K)


    As far as INITIAL and NEXT, I would look at how many devices you can spread your data on. If you have 10 devices, I would make the INITIAL and NEXT so I had about 10 extents on each device.
    My calc was based on 24,000,000 * 100 bytes = 2.4GB, since 12,000,000 rows inserted per day and kept for 2 days, so I presume each partition would hold 2 days' data.

Posting Permissions

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