Automatic Space Management Observation

From: Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us>
Date: Fri, 17 Dec 2004 09:55:42 -0500
Message-ID: <C9995D8C5E0DDA4A8FF9D68EE666CE0702A9714C@exchsen0a1ma>

All,

I finally turned ASM on in my 9.2 database. The tablespaces were created with no defaults - no uniform extent sizes.

Oracle created the tables all with 1M extent size. When loading a table, I notice that the first 64 extents were all 1M in size. The last 9 extents are all 8M in size.

So, is this how ASM works? Just curious if anyone else has had similar or different experiences?

Thomas Mercadante

Oracle Certified Professional

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Dec 17 2004 - 08:51:17 CST