-
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 12:24 AM.
-
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 04: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
-
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."
-
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"
-
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.
-
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
-
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"
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|