Automatic Space Management Observation

  • From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
  • To: Oracle-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 17 Dec 2004 09:55:42 -0500

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

 



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

Other related posts: