Re: DBA_TEMP_FILES.MAXBYTES is wrong

  • From: Greg Norris <spikey.mcmarbles@xxxxxxxxx>
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 30 May 2005 14:55:14 -0500

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@xxxxxxxxxx> 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

Other related posts: