Re: DBA_TEMP_FILES.MAXBYTES is wrong

From: Greg Norris <spikey.mcmarbles_at_gmail.com>
Date: Mon, 30 May 2005 14:55:14 -0500
Message-ID: <d4beff36050530125542152c43@mail.gmail.com>

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 <all_about_oracle_at_hotpop.com> wrote:
> Is your database 64 K block size?

>=20
>=20

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org=
]On
> Behalf Of Herring Dave - dherri
> Sent: Monday, May 30, 2005 10:27 PM
> To: Oracle-L_at_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.

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

Received on Mon May 30 2005 - 16:00:07 CDT