Oracle Database Discussions

Hi,

I have a warehouse database running on 11.1.0.7.0. The Enterprise Manager is reporting that Contention on the high watermark (HW) enqueue was consuming significant database time.

The tablespace has LOCAL Extent Management with SYSTEM ALLOCATION type. This is inherited by the tables under this tablespace, nothing at the table level overrides this. I've read somewhere that I probably need to change the Extent allocation to UNIFORM and assign bigger next extent sizes. However, I thougt with Extent management set to system allocation, Oracle would be 'clever' enough to auto-allocate approriate next extents.

Is it possible to change the extent management to UNIFORM with bigger extent sizes at the tablespace level without much downtime, or could I override this setting at the table level?

dula