Re: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments

There are various problems with ASSM that result in lost space - e.g. rollbacks do not reset the btmaps correctly. I also have an example (see the website below for " miscellaneous -> bust bits") which demonstrates that the implementation of ASSM has not been rolled out across all space management code points. Also, you get a couple of space management blocks per extent, rather than a few per segment.

On the other hand, my example is a special case, and if you don't care about leaking space all over the place, and if you have a problem relating to freelist (group) management in RAC, then ASSM may be a boon that you can afford to pay for. It's the usual cost/benefit/risk triangle.

Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Coming soon one-day tutorials:
Cost Based Optimisation
Trouble-shooting and Tuning
Indexing Strategies
(see http://www.jlcomp.demon.co.uk/tutorial.html )

____UK_______March 19th
____USA_(FL)_May 2nd

Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

____USA_(CA, TX)_August

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: 24 February 2003 16:29 comments

> All the hearsay evidence I've seen (including comments attributed to
Cary at
> his HotSOS symposium that I heard second hand last week) leads me to
believe
> that don't #5 is true...I must admit I've not done benchmarking
myself...
> :-)
>
> I am, however, ever open minded.
>
> RF
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Lewis
  INET: jonathan_at_jlcomp.demon.co.uk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).