Re: Why does a datafile extend a very large amount at very infrequent intervals?

From: Rich <richa03_at_gmail.com>
Date: Fri, 29 Jun 2012 10:56:47 -0700
Message-ID: <CALgGkeBi3MSXDZuDT-k9gBrJKR5q0FSZ6Jc9HmALEsUtwRaCtQ_at_mail.gmail.com>

[removing the rest of the email chain to prevent getting over-quoting] Hi Iordan,
Thanks for that - that should be documented here as well.

For those datafiles which are not totally full: select TABLESPACE_NAME, BYTES, MAXBYTES, MAXBLOCKS, INCREMENT_BY from dba_data_files where tablespace_name in ('RTDATA', 'RTINDX') and BYTES <> MAXBYTES; TABLESPACE_NAME BYTES MAXBYTES MAXBLOCKS INCREMENT_BY --------------- ------------- ------------- ------------- -------------

RTDATA            34359730176   34359721984       4194302             1
RTDATA            17834246144   34359721984       4194302          2056
RTDATA            34343026688   34359721984       4194302          2056
RTINDX            34343026688   34359721984       4194302          2056
RTINDX            34347155456   34359721984       4194302             1
RTINDX            34343026688   34359721984       4194302          2056
RTINDX            34343026688   34359721984       4194302          2056
RTINDX            34343026688   34359721984       4194302          2056
RTINDX            34309472256   34359721984       4194302          2056
RTINDX            34343026688   34359721984       4194302          2056
RTINDX            34309472256   34359721984       4194302          2056
RTINDX            24981340160   34359721984       4194302          2056
RTINDX               16842752   34359721984       4194302          2056
RTINDX               16842752   34359721984       4194302          2056
RTINDX               16842752   34359721984       4194302          2056
RTINDX            34343026688   34359721984       4194302          2056

I think INCREMENT_BY is in blocks, correct? The block sizes for both of these TSs is 8192 bytes. 2056 blocks * 8192 bytes is 16842752 bytes which is what I expect these datafiles to incrementally grow at...

On Fri, Jun 29, 2012 at 10:43 AM, Iotzov, Iordan <IIotzov_at_newsamerica.com>wrote:

> What is the INCREMENT_BY value in DBA_DATA_FILES? Autoextend is a DB file
> level attribute.
>
> Iordan Iotzov
> http://iiotzov.wordpress.com/
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jun 29 2012 - 12:56:47 CDT