Re: datafiles and tempfiles

"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message news:afrrs0$uof$1_at_lust.ihug.co.nz...
> I'm intrigued, Niall.
>
> I was in Hobart a month or two back. Being a "branch" office (a bit like
> Canberra, only worse, if you can imagine such a thing... sorry Richard!),
> they have no access to our central Solaris server. So the course was run
on
> NT workstations.
>
> I have a standard demo for why the 'tempfile' syntax was created: create
an
> old-fashioned datafile temporary tablespace of, say, 75M, and start
counting
> (go and make a cup of tea, have three smokes and a light snack whilst
> waiting). Then I create a tempfile temporary tablespace of size 750M, and
> Lo! It gets created in a second or so. This demo, of course, was perfected
> when using the Solaris machine.
>
> So here I go, on an NT box, spouting the same spiel as ever.... only to
> realise too late that NT wouldn't know a sparse file if it came up and hit
> it with a mackerel. So the demo goes "see how long this takes... now see
how
> long *this* takes.... er, er.... er... bugger".

Er Er bugger indeed . The NT box to which I refer is in fact a win2k (professional) box. This would appear to account for the difference.

<slopes off in a sulk having forgotten to read his own sig>

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************