Re: Maximum Usage of Temp Tablespaces Since Database Started
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Mon, 23 Jul 2012 16:35:31 +0000 (UTC)
Message-ID: <jujugj$gvs$4_at_solani.org>
On Mon, 23 Jul 2012 17:33:57 +0200, Michel Cadot wrote:
Date: Mon, 23 Jul 2012 16:35:31 +0000 (UTC)
Message-ID: <jujugj$gvs$4_at_solani.org>
On Mon, 23 Jul 2012 17:33:57 +0200, Michel Cadot wrote:
> As Oracle never deallocates extents in temporary tablespaces,
> the maximum usage is the current size.
> So your query is good, in my opinion.
This is a better answer than what I have come up with.
-- http://mgogala.byethost5.comReceived on Mon Jul 23 2012 - 11:35:31 CDT