Re: Maximum Usage of Temp Tablespaces Since Database Started

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Mon, 23 Jul 2012 17:33:57 +0200
Message-ID: <500d6ee9$0$6128$>

<> a écrit dans le message de news:
| 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

As Oracle never deallocates extents in temporary tablespaces, the maximum usage is the current size.
So your query is good, in my opinion.

Michel Received on Mon Jul 23 2012 - 10:33:57 CDT

Original text of this message