i've had this issue with raw device database on 9.2.0.4. havent had a chance to investigate it in detail.. Greg Norris <spikey.mcmarbles@xxxxxxxxx> wrote:My guess would be that the files are sparse. What are the results of 'du -k'? Does it match up with the 'ls -l' output? On 5/30/05, Oracle wrote: > Is your database 64 K block size? >=20 >=20 > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx= ]On > Behalf Of Herring Dave - dherri > Sent: Monday, May 30, 2005 10:27 PM > To: Oracle-L@Freelists. Org (E-mail) > Subject: DBA_TEMP_FILES.MAXBYTES is wrong >=20 > 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): [snipped] --=20 "I'm too sexy for my code." - Awk Sed Fred. -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l