locally manged tablespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: locally manged tablespace

  1. #1
    Join Date
    Apr 2003
    Posts
    46

    locally manged tablespace

    hi

    how would i change a locally managed permanent tablespace to a temporary tablespace.

    i had another query , i was going through a book where i have db_block_size of 8kb, the size of third extent would be 12kb if initial is 8k, next is 8k , pctincrease is 50% and minextents is 3 , hence the total extent size would be 28kb
    (8+8+12) but the ans that comes is 40kb as total size and third extent is 16k.how?

    another question said if i had db_block_size of 4kb, and i create a tablespace with no default storage it assigns 5*db_block_size as initial and next, pctincrease is taken as 50% so what is the size of the third extent.
    according to the book third extent would be 32kb. how?

    thanks
    Last edited by ser; 06-21-2003 at 01:24 AM.

  2. #2
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    You say your db block size is 8k. So how many blocks should contain 12k extent? One and a half???
    It gets rounded on next full block
    I. 8k, 8k, 12k=>16k
    II. 20K, 20K, 30k=>32k
    Last edited by TomazZ; 06-21-2003 at 05:50 AM.
    Tomaž
    "A common mistake that people make when trying to design something completely
    foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams

  3. #3
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796

    Re: locally manged tablespace

    Originally posted by ser
    hi

    how would i change a locally managed permanent tablespace to a temporary tablespace.
    Just create a new temporary tablespace and drop the permanent. That would be much simpler and quicker than posting that question.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  4. #4
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434

    Re: locally manged tablespace

    Originally posted by ser
    (8+8+12) but the ans that comes is 40kb as total size and third extent is 16k.how?
    it will be 8+8+16 ( 8+4 = 12 rounded to 16 ) = 32, not 40k.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  5. #5
    Join Date
    May 2001
    Posts
    736
    If iam right he got the question from sybex.There the guys added

    8+8+16= 32 + 8block size so the total becomes 40k.But why they added the blocksize to the total there is no explanation.

  6. #6
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    Ha, I missed that part of the question...
    Because minimum initial size is 2*block_size.
    so when you specify initial 8k next 8k pctincrease 50%, you get 3 extents as:
    16k, 8k, 16k
    sum 40k
    Tomaž
    "A common mistake that people make when trying to design something completely
    foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams

  7. #7
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by TomazZ
    Because minimum initial size is 2*block_size.


    rechecked the manual, Min is 2*block_size if space management is manual & its 3*block_size if automatic...

    Also, for every freelist group an extra block_size is needed.

    so 2*block_size + 1*Number_Of_Freelists_group.

    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  8. #8
    Join Date
    Dec 2001
    Location
    Brazil
    Posts
    282
    Originally posted by akhadar
    But why they added the blocksize to the total there is no explanation.
    Maybe this block means the segment header block ... ?!


    F.

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