Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: datafiles and tempfiles

Re: datafiles and tempfiles

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Tue, 2 Jul 2002 22:24:10 +0100
Message-ID: <3d2219fb$0$8513$cc9e4d1f@news.dial.pipex.com>


"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3D21D2D2.6DD24E26_at_exesolutions.com...
> Just did the following:
>
> SQL> SET TIMING ON
> SQL> CREATE TEMPORARY TABLESPACE temptest TEMPFILE
> 'c:\temp\temptest01.dbf' SIZE 400M;
>
> Tablespace created.
>
> Elapsed: 00:00:04.16
> SQL>
>
> on an IBM 380Z ThinkPad, 300MHz CPU with 64MB RAM, WinNT 4 SP 6, Oracle
> 8.1.7.0.0 Enterprise Edition. The disks are configured as NTFS.

Seems pretty good to me.perhaps its Oracle version dependent as well

--
Niall Litchfield
Oracle DBA
Audit Commission UK
Received on Tue Jul 02 2002 - 16:24:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US