Re: DBA_TEMP_FILES.MAXBYTES is wrong

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Fri, 03 Jun 2005 00:47:22 +0000
Message-Id: <1117759642l.5535l.0l@medo.noip.com>

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

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jun 02 2005 - 20:52:20 CDT