Re: SQL query to determine the users of undo tablespace

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