Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: 9i - ASSM
Jonathan, can you expand on the bugs you reference and how the CBO is
fooled? We have the same debate going on here.
If you have bug numbers and a nice example of the CBO choking, that would be very helpful.
Thank you
Lisa Koivu
Orlando, FL, USA
-----Original Message-----
From: Jonathan Lewis [mailto:jonathan_at_jlcomp.demon.co.uk]
Sent: Friday, March 05, 2004 3:33 AM
To: oracle-l_at_freelists.org
Subject: Re: 9i - ASSM
"Oracle features are like fine wines - they should be allowed to mature for a few years before you try them"
(Tom Kyte - re-interpreting the commonest reason he had heard for people avoiding new features).
On this one, my sympathies lie with your senior DBA.
On the other hand, ASSM is clearly the strategic direction for Oracle - so at some stage you'll have to go with the flow. You could compromise - by testing in production - design you tablespace strategy with a view to being able to move objects from freelist to assm (and back again) with minimum pain, a few at a time.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
March 2004 Hotsos Symposium - The Burden of Proof
Dynamic Sampling - an investigation
March 2004 Charlotte OUG (www.cltoug.org) CBO Tutorial
April 2004 Iceland
June 2004 UK - Optimising Oracle Seminar
: 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
:
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- "The sender believes that this E-Mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking proactive and remedial action about viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments." ---------------------------------------------------------------- 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 Fri Mar 05 2004 - 10:35:48 CST
![]() |
![]() |