Re: LOCALLY MANAGED EXTENT PERFORMANCE

Hi,

One more performance-related thing with relying purely on autoextend is, that if your segments need to allocate a new extent and has to extend the datafile for it, then your session has to wait until the datafile is resized before it can use any blocks of this new extent. There are quite a few systems for which those even few-second hangs are unacceptable or should be avoided.

Tanel.

• Original Message ----- From: "Dogan, Ibrahim - Ibrahim" <Ibrahim.Dogan_at_Lowes.com> To: <tim_at_evdbt.com>; <oracle-l_at_freelists.org> Sent: Tuesday, April 26, 2005 7:24 PM Subject: RE: LOCALLY MANAGED EXTENT PERFORMANCE

>
> Ever heard "3 Party App" where you have no access to the code?
>
> I was also temped by the theory that number of extents don't matter much
> but I changed my mind after testing LMT with uniform extents for a 3.
> party app in which there are several tables that jump to 3-4G from 0
> bytes during day..all users started screaming and we had to go to LMT
> with auto allocate to calm down the users...
>

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