Re: DBA_TEMP_FILES.MAXBYTES is wrong

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

Other related posts: