Re: SQL query to determine the users of undo tablespace

"Mladen Gogala" <mgogala.SPAM-ME.NOT_at_verizon.net> a écrit dans le message de 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

I had no purpose, I just explained what can be happened. I never used it. Maybe it will be useful if you lose one file in the current undo tablespace to switch to another one hoping you don't have a transaction that goes to the unavailable file. Or when you want to put your undo tablespace onto another disk without shutting down the database. There may be multiple reasons to do that.

Regards
Michel Cadot Received on Fri Apr 06 2007 - 12:35:12 CDT