and if the datafile autoextends by 10m and the next extent request is
64m (or even 256m) how many file resize requests get issued? Not 1
last time I tested.
On 4/26/05, Tanel P=F5der <tanel.poder.003_at_mail.ee> wrote:
> Hi,
>=20
> 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 resi=
zed
> 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.
>=20
> Tanel.
>=20
> ----- 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
>=20
> >
> > 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 muc=
h
> > 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...
> >
>=20
> --
> http://www.freelists.org/webpage/oracle-l
>=20
--=20
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Apr 26 2005 - 15:30:10 CDT
