Re: LOCALLY MANAGED EXTENT PERFORMANCE
- From: Tanel Põder <tanel.poder.003@xxxxxxx>
- To: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 26 Apr 2005 20:07:25 +0100
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@xxxxxxxxx>
To: <tim@xxxxxxxxx>; <oracle-l@xxxxxxxxxxxxx>
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...
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
