Re: Maximum Usage of Temp Tablespaces Since Database Started

From: Mladen Gogala <>
Date: Mon, 23 Jul 2012 15:46:01 +0000 (UTC)
Message-ID: <jujrjp$gvs$>

On Mon, 23 Jul 2012 07:34:01 -0700, basis_consultant wrote:

> Hi,
> We are running a large ERP system on Oracle 10g (I know that we should
> not be on 10g-Will be upgrading to Oracle 11 soon).
> There are 6 temporary tablespaces with a size of 16GB each.
> Is there any way to find out the maximum bytes used by the temp.
> tablespaces since the database was started?
> I suppose that I can approximate by having a script run "select
> regularly, but I am hoping that there is a better way.
> Thanks,
> QZ

That is simple. V$ACTIVE_SESSION_HISTORY has that information per user session. You should join with the DBA_USERS, group by temporary tablespace and sample_time and compute the sum for each group.

Received on Mon Jul 23 2012 - 10:46:01 CDT

Original text of this message