Re: Locally managed Temporary tablespaces

Comments in-line.

On 06/09/2005 09:15:57 AM, Peter Dixon wrote:
> I have performed a healthcheck on our production database , I am running=20
> 8.1.7.4 on hp11.11 with the database files running on a san (raid 5).=20

Baarf! To be more precise http://www.baarf.com.

>I was=20
> surprised to see the average read time for the temporary tablespace as 82=
6ms=20

826ms? That is 0.83 sec? You should not put your temporary tablespace onto = a=20
5.25" floppy drive. If I remember correctly, there were some 8" floppies wi= th=20
approximately that speed, which were extremely popular on RSX+ machines.

> where all the other tablespaces in the database are around 10ms. Would it=
 be=20
> a wise to move the temporary tablespace data files onto another sort of d=
isk=20
> storage?

What do sar -d and glance (gpm) say about response times of your disk drive= s?
=46rom what you described, it looks like a steam powered disk would be a real= =20
improvement.

--=20
Mladen Gogala
Oracle DBA

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