Hello all,
I'm puzzled with the value returned by dba_extents:
In my case I have a LMT with this storage definition :
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 40K
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT MANUAL
I'm expecting that my next extents are with size 40K
Yet, they are not:
select * from dba_extents a
where A.TABLESPACE_NAME = 'X'
| EXTENT_ID | FILE_ID | BLOCK_ID | BYTES | BLOCKS |
| 37 | 672 | 635548 | 4031078400 | 492075 |
| 36 | 672 | 128 | 2687385600 | 328050 |
| 35 | 617 | 9 | 1791590400 | 218700 |
....
....
And the same extent_id has multiples rows in dba_extents ?
EXTENT_ID FILE_ID BLOCK_ID BYTES BLOCKS RELATIVE_FNO
17 321 121065 29491200 3600 321
17 152 102422 29491200 3600 152
17 152 58667 29458432 3596 152
17 11 36432 29491200 3600 11
17 308 45452 29491200 3600 308
17 351 2240 29458432 3596 351
17 152 52822 29491200 3600 152
17 308 76952 29458432 3596 308
17 152 98822 29491200 3600 152
17 351 243306 29458432 3596 351
17 308 69451 29458432 3596 308
17 152 49222 29491200 3600 152
Any explanation for this ?
Thank you.