Re: Creating a database is slow on Windows XP

10 minutes, whow that's fast :)

You can create a new database from sqlplus using 'create database' SQL statement.
That's fast too.
DCA creates the db and runs a complete set of scripts to load all PL/SQL API's. On my server this makes over 200 MB of data.

To speed up creation, you can tell DCA NOT to generate the DB but to build a creation script for you. In this script you can comment out subscripts creating obsolete parts of system schema (like oracle 7 compatible replication views or other junk)...

On 12 May 2004 20:11:23 -0700, Dim St Thomas <dimstthomas_at_yahoo.com> wrote:

> I am a developer working on a database client program. I am testing this
> program on a Windows XP machine (1.5 GHz AMD chip, 480 Mb RAM, 60 Gb
> disk)
> This machine has Oracle 9.2.0.1.0 and RedBrick database software
> installed.
> I am testing the software by creating small test databases.
> If I create an Oracle database using the Database Configuration
> Assistant,
> it takes forever just to create the database. If I choose to create a
> new database and deselect all the options (Example Schemas, Data Mining,
> OLAP, JVM, Intermedia etc) it still takes 10 minutes to create the
> database. With RedBrick I can create a database in less than 10 seconds.
> Once the database has been created, loading and accessing the data
> takes about the same time with Oracle and RedBrick.
>
> So here are my questions:
> 1. Why does Oracle take so long just to create an empty database/
> what is it doing during database creation?
> 2. Oracle includes tuning tools, but I think these are only for use
> on existing databases. Is there any Oracle settings I can change to
> speed up database creation?
> 3. If I installed more memory on my machine would it significantly
> speed up database creation?
>
> Thanks

-- 
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/