RE: DBA_TEMP_FILES.MAXBYTES is wrong
- From: "Herring Dave - dherri" <Dave.Herring@xxxxxxxxxx>
- To: <spikey.mcmarbles@xxxxxxxxx>, "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 30 May 2005 17:15:54 -0500
My database uses a 32K block size, all on advfs.
A comparison of 'ls -l' to 'du -k' shows only 8 bytes difference per
directory total.
I guess the easy solution is to set my initial size of each tempfile to
that of the maxsize. My worry is forgetting about the base problem and
it somehow biting me. I'd point it out to Oracle but I have a feeling
the response will be, 'but it works under 10g'.
Dave
-------------------------------------
Dave Herring, DBA
Acxiom Corporation
3333 Finley
Downers Grove, IL 60515
wk: 630.944.4762
<mailto:dherri@xxxxxxxxxx>
-------------------------------------
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> On Behalf Of Greg Norris
> Sent: Monday, May 30, 2005 2:55 PM
> To: ORACLE-L
> Subject: Re: DBA_TEMP_FILES.MAXBYTES is wrong
>=20
> 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?
>=20
> On 5/30/05, Oracle <all_about_oracle@xxxxxxxxxx> wrote:
> > Is your database 64 K block size?
> >
**********************************************************************
The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged.
If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination,=20
distribution, or copying of this communication is strictly
prohibited.
If you have received this communication in error,
please re-send this communication to the sender and
delete the original message or any copy of it from your
computer system. Thank You.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
