Relating actual object size to Storage parameters
- From: "Paul Vincent" <Paul.Vincent@xxxxxxxxx>
- To: "Oracle-L@Freelists. Org (E-mail)" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 15 Sep 2004 07:46:10 +0100
I just spotted something puzzling. I was checking the sizing of some
Oracle 8i tables, using TOAD's Schema Browser. There are tables and
indexes which have initial and next extent sizes of 409600 (400K), have
only a single extent, yet the "Size in bytes" is given as 524288 (512K).
The db_block_size is 8192 (8K), and 400K is a multiple of 8K, so why do
the storage parameters for these objects appear to have been ignored?
Any ideas?
Paul Vincent
Database Administrator
University of Central England
--
//www.freelists.org/webpage/oracle-l
Other related posts:
