Re: SQL query to determine the users of undo tablespace

On Apr 7, 8:21 am, "Matthias Hoys" <a..._at_spam.com> wrote:
> "Mladen Gogala" <mgogala.SPAM-ME...._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

Makes one wonder whether TEMP and UNDO tablespaces need to be on the expensive disk.

/Hans Received on Sat Apr 07 2007 - 10:56:45 CDT