Re: SQL query to determine the users of undo tablespace

"Mladen Gogala" <mgogala.SPAM-ME.NOT_at_verizon.net> wrote in message news:pan.2007.04.06.17.14.53_at_verizon.net...
> On Fri, 06 Apr 2007 17:20:13 +0200, Michel Cadot wrote:
>
>> You can switch from one tablespace to othe another when transactions are
>> active. New transactions go to the new undo tablespace when old ones go
>> on on the previous one.
>
> Hmmm, interesting. I guess that the goal is to allocate separate UNDO
> tablespace for big batches? Unfortunately, that solution suffers from the
> same problems as the rollback segment one: it works as long as the "big
> batch" doesn't commit. After that, it uses the new undo segments. My
> phylosophy is that disks are cheap, especially if somebody else is paying
> for them, ao I allocate as much space for the UNDO tablespace as needed.
>
> --
> http://www.mladen-gogala.com

True, disks are cheap, but if your SAN is full and you need a new storage cabinet, FC switches and licenses, it's getting more expensive :-)

Matthias Received on Sat Apr 07 2007 - 09:21:44 CDT