Re: 9i - ASSM

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Fri, 5 Mar 2004 01:44:22 +0200
Message-ID: <15b501c40242$9fe50520$a2a623d5@porgand>

Hi Mark,

If you want to get some idea how ASSM and Freelist management work internally, check my presentation
http://integrid.info/Poder_Freelists_vs_ASSM.ppt

Unfortunately there is no paper, but there are pros and cons of both brought out in the last slides.

Personally I would go with ASSM if implementing a new system, especially if it's gonna be RAC.
But there have been and likely still are some bugs, such ASSM managed LOB segments (which are available starting from 9.2) not reusing free space, so be sure to test your configuration before going live. Check 10g release notes and see which ASSM related bugs they have fixed in that version, from there you can find out some of the problems which you might encounter in 9.2.

And don't take these claims seriously, that ASSM is slower "because if I inserted 1M records into an ASSM table, the full table scan took 2 more seconds than with freelist managed one". Real life systems don't just bulk insert once and do full table scans from there.

Tanel.

Original Message ----- From: "Mark Moynahan" <Mark.Moynahan_at_apollogrp.edu> To: <oracle-l_at_freelists.org> Sent: Thursday, March 04, 2004 11:49 PM Subject: 9i - ASSM

> We are having a debate on building tablespaces with automatic segment
space
> management (ASSM). This is a 9i db on a Solaris box. I'm in favor of using
> ASSM but the senior dba is a bit hesitant and want to put in manual mode.
> I've even tried to persuade him with the Oracle documentation but he
insists
> its not mature enough for production.
>
> Is there any white papers or matalink papers that show the pros and cons
to
> ASSM in 9i? Has anyone had issues with using ASSM? Is there a way of
proving
> ASSM is better than MSSM?
>
> Thanks,
>
> Mark
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Mar 04 2004 - 18:19:37 CST