Re: Relocating undo tablespace

From: EdStevens <quetico_man_at_yahoo.com>
Date: 8 Mar 2006 07:32:12 -0800
Message-ID: <1141831932.008813.12940@p10g2000cwp.googlegroups.com>

Herod wrote:
> Your kidding right?
>
> That is the kind of thing statspack is exactly for.
>
> And as long as the database is brought up properly, only one copy of
> the file is correct - EdStevens is correct
> as well as the rest of us that said to do that :)

In Mladen's defense, I'm not sure I see how statspack will show anything about where the SA placed a file system. What it will show is poor performance. It can even point that the poor performance is due to too many xxx_write wait events. That MAY (or may not) be due to the configuration of the disk farm. I don't think statspack can distinguish a db_file_parallel_write on a RAID-5 system from that on a SAME system. Received on Wed Mar 08 2006 - 09:32:12 CST