Re: Oracle 10g = bloatware?
From: Matthias Hoys <matthias.hoys_at_gmail.com>
Date: Thu, 12 Apr 2012 01:10:35 -0700 (PDT)
Message-ID: <30655516.53.1334218235236.JavaMail.geo-discussion-forums_at_vbuc18>
On Thursday, April 12, 2012 3:39:47 AM UTC+2, onedbguru wrote:
>
> OR, they have have had a LOT of inserts/deletes over time and never did a shrink space to clean it up (assuming ASSM).
Date: Thu, 12 Apr 2012 01:10:35 -0700 (PDT)
Message-ID: <30655516.53.1334218235236.JavaMail.geo-discussion-forums_at_vbuc18>
On Thursday, April 12, 2012 3:39:47 AM UTC+2, onedbguru wrote:
>
> OR, they have have had a LOT of inserts/deletes over time and never did a shrink space to clean it up (assuming ASSM).
This is a table from APEX - there are about 6800 records for 4 years of usage. Mostly inserts, no updates, some deletes... The tablespace is indeed using ASSM, with automatic extent allocation...
Matthias Received on Thu Apr 12 2012 - 03:10:35 CDT