Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2003
    Posts
    23

    Arrow Unanswered: value initial,next

    Hello everybody,

    Iam confused with the parameter initial,next while creating a table.

    1) What is the value for initial and next for a table which does both
    insert and update. What is the yard-stick that i must follow.
    Also what is the pctfree , pctused must i use ?

    Please mail me at manips15@hotmail.com

    Regards
    Mani PS

  2. #2
    Join Date
    Feb 2002
    Location
    San Francisco, CA
    Posts
    441
    This isn't an ASP question...

  3. #3
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    INITIAL is the initial size of the table you are going to create...
    NEXT is the next extent size to allocate in the tablespace once the
    table needs to expand.... You have to determine the size based on the
    number of records in the table ... or how many you think there will be
    in the future ...

    Attached is a piece of code that you can run ... answer the questions
    it asks and it will give you some idea of the size of the table ...

    PCTFREE - what % of the datablocks of the table do you want to
    keep free for updates to rows already in the datablock.
    PCTUSED - Once a datablock becomes full (pctfree), Oracle will not
    consider an INSERT into that datablock until the free space in the
    datablock falls below PCTUSED ...

    These 2 parameters help with row chaining ....

    HTH
    Gregg
    Attached Files Attached Files

Posting Permissions

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