Re: Locally managed Temporary tablespaces

From: Connor McDonald <mcdonald.connor_at_gmail.com>
Date: Fri, 10 Jun 2005 12:10:55 +0800
Message-ID: <5e30486205060921102ac83bdb@mail.gmail.com>

Temp tspace is one of the few places where you will concurrent *write* activity (database files all being done with one or just a few db writers) so maybe the read time is suffering from concurrent write activity ?

You could validate this to some degree by having lots of temporary tablespaces (and hence of temp files) and round-robin-ing them among users to spread the load.

hth
connor

On 6/9/05, Peter Dixon <peterdixon001_at_hotmail.com> wrote:
> I have performed a healthcheck on our production database , I am running
> 8.1.7.4 on hp11.11 with the database files running on a san (raid 5). I w=
as
> surprised to see the average read time for the temporary tablespace as 82=
6ms
> where all the other tablespaces in the database are around 10ms. Would it=
 be
> a wise to move the temporary tablespace data files onto another sort of d=
isk
> storage?

>=20

> Peter Dixon
> 8i OCP

>=20
>=20

> --
> http://www.freelists.org/webpage/oracle-l
>=20

--=20
Connor McDonald
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D
email: connor_mcdonald_at_yahoo.com
web: http://www.oracledba.co.uk

"Semper in excremento, sole profundum qui variat"

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

Received on Fri Jun 10 2005 - 00:16:00 CDT