We're on Solaris 9205 and have "0" for dba_temp_files.maxbytes no matter how much sorting is occurring. We just regularly keep an eye on v$sort_usage. hth connor On 5/30/05, Herring Dave - dherri <Dave.Herring@xxxxxxxxxx> wrote: > Has anyone had an issue with MAX* columns within DBA_TEMP_FILES being > wrong? >=20 >=20 > I've got one temp tablespace, type temporary, defined for all users and > the default at the database level (9.2.0.4 on Tru64). This temp > tablespace has 6 tempfiles defined, each created with a maxsize of > 40,001M (see results of an 'ls -l' below): >=20 >=20 --=20 Connor McDonald =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D email: connor_mcdonald@xxxxxxxxx web: http://www.oracledba.co.uk "Semper in excremento, sole profundum qui variat" -- //www.freelists.org/webpage/oracle-l