Re: maxbytes on dba_temp_files

From: mario <xnazsco_at_tiscali.it>
Date: Fri, 06 Aug 2004 09:06:01 +0200
Message-ID: <pan.2004.08.06.07.06.01.94340@tiscali.it>

Hi Howard,
thank's for your answer.
Normally I do not use autoextend. We are upgrading the software that manage our Advertising platform, and there are some sql scripts that join tables whith 300 bilions of records sorting them.
As we finish the migration autoextend clause will be set to off of course.

regards
M.

Il Fri, 06 Aug 2004 06:27:41 +1000, Howard J. Rogers ha scritto:

>
> "mario" <xnazsco_at_tiscali.it> wrote in message
> news:pan.2004.08.05.09.37.25.309133_at_tiscali.it...

>> Hi all,
>> maxfiles on dba_data_files show 1.7180E+10
>> but I have created the datafiles with autoextend on
>> maxsize unlimited.
>> It is the way oracle show that the datafiles has not limits?

>
>
> Yes. It's an awfully big number, which is effectively unlimited.
>
> You do realise that autoextend is a potentital disaster waiting to happen,
> though, don't you? Bear in mind that the data file is, essentially, the
> basic unit of backup and recovery... so whilst you are referring to TEMP
> files in your subject and that wouldn't be so much of a worry because they
> are never backed up or recovered anyway, you actual post mentions
> dba_DATA_files, and they really would be a worry if allowed to grow
> uncontrollably.
>
> Even for TEMP it's not such a hot idea. Performance for one thing
> (auto-extension is a slow process). And a rogue query blowing it out to some
> enormous size for another.
>
> Any reason you can't size your files properly in the first place, and add
> new ones when the old ones are full?
>
> Regards
> HJR
>
>
>
>

>> We use oracle 9.2.0.1.0 Enterprise Edition.
>>
>> Thank's

Received on Fri Aug 06 2004 - 02:06:01 CDT