|
-
I have a doubt in extents allocation.
Assume a tablespace called 'PAYROLL' having following defaults.
TABLESPACE_NAME MIN_EXTENTS MAX_EXTENTS PCT_INCREASE
--------------- ----------- ----------- ------------
PAYROLL 1 505 50
and I have created on table called TEST by logging in as a user whose default tablespace is this payroll tablespace.
create table test ( i integer)
storage (initial 1k next 1k minextents 1 maxextents 2)
Now if I run the following query
SQL> select segment_name,sum(blocks),bytes from dba_extents group by segment_name,bytes
having segment_name = 'TEST'
SEGMENT_NAME SUM(BLOCKS) BYTES
-------------------- ----------- ---------
TEST 2 16384
And the DB_BLOCK_SIZE = 8192 (8k)
I assumed that there should be the value 1 in the sum(blocks) and 8192 in the bytes column because
the block size is 8k and so there should be only one block.
But it is different and it is taking 2 blocks with 16384.
Can anyone clear this...?
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
|