Home » RDBMS Server » Enterprise Manager » Reorg Wizard Unexpected results
Reorg Wizard Unexpected results [message #68678] Mon, 14 June 2004 06:34
Terry Burns
Messages: 13
Registered: January 2004
Junior Member
Reorg Wizard, Unexpected results

I am evaluating the oracle tools (OEM & Packs) and after using the reorg wizard to do an online table reorg I have some unexpected results. Before the reorg a query against the dba_segments table indicated that the table had initial extent of 16M next extent of 64k and was using 620 extents. After the reorg initial extent was 55M, next extent 64K and 880 extents. I was expecting the number of extents to drop to 1. Did I miss a compress extents option some where ?? Why the increase of 260 extents?? 

I'm running OEM version 9.2.x against a database.

Thanks in advance
Previous Topic: jobs stored where?
Next Topic: Replication Problem in oracle 8i
Goto Forum:

Current Time: Sun May 22 12:23:27 CDT 2022