Re: DBA_TEMP_FILES.MAXBYTES is wrong

From: Fuad Arshad <fuadar_at_yahoo.com>
Date: Mon, 30 May 2005 13:44:05 -0700 (PDT)
Message-ID: <20050530204405.20843.qmail@web80508.mail.yahoo.com>

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_at_gmail.com> 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_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



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

Received on Mon May 30 2005 - 16:49:04 CDT