Re: Undo Tablespace Question

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Wed, 23 Nov 2005 14:22:03 GMT
Message-Id: <pan.2005.11.23.14.22.02.686152@sbcglobal.net>

On Tue, 22 Nov 2005 07:31:37 -0800, amerar_at_iwc.net wrote:

> Diskspace is being used up rapidly. Guess I can drop the undo
> tablespace and rebuild it........

First, you should take a peek into V$UNDOSTAT and see how many blocks are generated and what has generated them. You should also take a look at your maxquerylen column and see whether you have any long running queries. When you find out what is generating excessive undo, you can decide what to do.

-- 
http://www.mgogala.com

Received on Wed Nov 23 2005 - 08:22:03 CST