locally manged tablespace

Printable View

06-21-2003, 12:09 AM
ser

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
06-21-2003, 04:48 AM
TomazZ

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
06-21-2003, 06:12 AM
adewri

Re: locally manged tablespace

Quote:

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.
06-23-2003, 02:27 AM
abhaysk

Re: locally manged tablespace

Quote:

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.
06-23-2003, 03:20 AM
akhadar

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.
06-23-2003, 05:03 AM
TomazZ

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
06-23-2003, 05:48 AM
abhaysk

Quote:

Originally posted by TomazZ
Because minimum initial size is 2*block_size.

:) :cool:

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.
06-23-2003, 09:57 AM
Mnemonical

Quote:

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.