Re: How to revert to DMTS ?
From: Charles Hooper <hooperc2000_at_yahoo.com>
Date: Fri, 1 Oct 2010 04:56:26 -0700 (PDT)
Message-ID: <43e022ca-8285-4479-be86-7b7cc1dcf7ad_at_w19g2000yqb.googlegroups.com>
On Sep 30, 3:21 pm, "Gerard H. Pille" <g..._at_skynet.be> wrote:
> Excessive undo on intensive deletes and inserts in indexes, multiple sessions inserting (DMTS +
> freelists) and slower full table scans.
Date: Fri, 1 Oct 2010 04:56:26 -0700 (PDT)
Message-ID: <43e022ca-8285-4479-be86-7b7cc1dcf7ad_at_w19g2000yqb.googlegroups.com>
On Sep 30, 3:21 pm, "Gerard H. Pille" <g..._at_skynet.be> wrote:
> Excessive undo on intensive deletes and inserts in indexes, multiple sessions inserting (DMTS +
> freelists) and slower full table scans.
You can use freelist management with locally managed tablespaces - you
do not need to use ASSM:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/tspaces.htm#sthref1155
Charles Hooper
Co-author of "Expert Oracle Practices: Oracle Database Administration
from the Oak Table"
http://hoopercharles.wordpress.com/
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc.
Received on Fri Oct 01 2010 - 06:56:26 CDT