Lost in space/space lost, a space management problem

From: <sybrandb_at_my-deja.com>
Date: Thu, 03 Jun 1999 07:42:18 GMT
Message-ID: <7j5bkp$9q3$1@nnrp1.deja.com>

Hi,

I have the following situation (Oracle 7.3.4 on Solaris) An index has been created with an initial extent of 56k, and a next extent of 80k, the total size of the index is 30 Oracle blocks (240k), in 3 extents.

According to our repository the initial extent should have been 50k and the next extent 50k.
I can see the initial extent has been rounded to a multiple of 8k, the current block size. I more or less can imagine the minimum next extent is 10 Oracle blocks, so 80k, although it means Oracle ignores the storage parameters.
Yet that still doesn’t account for 3 Oracle blocks. Perhaps the index header is one of them, then I still have a situation where the final storage parameter do not match in any way what has been specified at creation of the index.
What’s happening?

Thanks,
--

Sybrand Bakker, Oracle DBA

All standard disclaimers apply

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Jun 03 1999 - 02:42:18 CDT