Re: Maximum Usage of Temp Tablespaces Since Database Started
Date: Mon, 23 Jul 2012 17:33:57 +0200
Message-ID: <500d6ee9$0$6128$426a74cc_at_news.free.fr>
<basis_consultant_at_hotmail.com> a écrit dans le message de news: 5be655fa-4172-4461-be9e-1ea2f976a6db_at_googlegroups.com...
| 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.
Regards
Michel
Received on Mon Jul 23 2012 - 10:33:57 CDT