Re: Maximum Usage of Temp Tablespaces Since Database Started
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Mon, 23 Jul 2012 15:46:01 +0000 (UTC)
Message-ID: <jujrjp$gvs$2_at_solani.org>
On Mon, 23 Jul 2012 07:34:01 -0700, basis_consultant wrote:
Date: Mon, 23 Jul 2012 15:46:01 +0000 (UTC)
Message-ID: <jujrjp$gvs$2_at_solani.org>
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
> TABLESPACE_NAME, BYTES_USED, BYTES_FREE from V$TEMP_SPACE_HEADER"
> 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.
-- http://mgogala.byethost5.comReceived on Mon Jul 23 2012 - 10:46:01 CDT