Re: DBA_TEMP_FILES.MAXBYTES is wrong
- From: Mladen Gogala <gogala@xxxxxxxxxxxxx>
- To: mcdonald.connor@xxxxxxxxx
- Date: Fri, 03 Jun 2005 00:47:22 +0000
On 06/02/2005 08:16:06 PM, Connor McDonald wrote:
> We're on Solaris 9205 and have "0" for dba_temp_files.maxbytes no
> matter how much sorting is occurring.
>=20
> We just regularly keep an eye on v$sort_usage.
V$SORT_USAGE is a very useful table. You can concoct some monstrous queries=
,=20
like the following:
select space,tot "Total",usd "Used",(1-(usd/tot))*100 "%Free"
from (
select
tf.tablespace_name space,tf.total tot,nvl(tu.used,0) usd
from (select tablespace_name,round(sum(bytes)/1048576) total
from dba_temp_files
group by tablespace_name) tf,
(select tablespace,
round(sum(s.blocks*t.block_size)/1048576,2) used
from v$sort_usage s,dba_tablespaces t
where s.tablespace=3Dt.tablespace_name
group by tablespace) tu
where tf.tablespace_name=3Dtu.tablespace )
--=20
Mladen Gogala
Oracle DBA
--
//www.freelists.org/webpage/oracle-l
Other related posts:
