-
Dba's,
I have anlyzed my existing DB which uses dictionary managed tablespaces and found initial extent sizes ranging from 40 - 100Mb (for different tables of course) which I find too much.
Both DBA_TABLES and DBA_EXTENTS show one extent allocated to the table of size 40 - 100MB
I am pllaning a reorg and testing the use of LMT's. I ceated a LMT with uniform allocation of 512K extents.
After import, I analyzed my tables again and guess what?
DBA_TABLES show an initial extent size of 40 - 100 MB (original).
DBA_EXTENTS show an number of extents allocated of uniform size 512K.
Why is this discrepancy and what is right? And how do I achieve smaller extent sizes for my segments?
Thanks,
Nizar
-
When you specify your INITIAL and NEXT extent values for an object, Oracle is smart enough to go out and allocate that much space in 512K chunks.
Jeff Hunter
-
I am trying to learn about LMT's. (Old dog.......)
When you did your import did it go to the LMT or the DMT?
I though Oracle ignored initial and next sizes for LMT's?
Joseph R.P. Maloney, CSP,CDP,CCP
'The answer is 42'
-
It depends how u created ur LMT, if u specified uniform extent then ORacle
respects ur table storage clause and shall allocate extents
equal to or round off to ur initial extent in multiples of uniform extent
size specified at tablespace level.
-
Marist,
Please clear me on this.
Yes - My object has storage parameters of initial 100M.
My LMT has uniform extent allocation of 512 K.
Are you saying that during the import process when Oracle creates that table, 200 extents of 512 K are allocated. And this is what DBA_EXTENTS reports.
And DBA_Tables report 100M because initially 100M space is allocated for the table.
Is this right?
Thanks,
Nizar
-
Originally posted by nabaig
Are you saying that during the import process when Oracle creates that table, 200 extents of 512 K are allocated. And this is what DBA_EXTENTS reports.
Yup.
And DBA_Tables report 100M because initially 100M space is allocated for the table.
You got it.
Jeff Hunter
-
Jeff,
Thanks a ton.
Nizar.
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
|