OraFAQ Forum: Server Administration » Can I create more than one DB at the same time?

Home » RDBMS Server » Server Administration » Can I create more than one DB at the same time?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Can I create more than one DB at the same time? [message #59915]

Sat, 03 January 2004 13:41

scott
Messages: 73
Registered: September 1999

Member

Im trying to create databases using scripts. Doing it one by one has been a success so far and also a waste of time. Is there anyway I could parallelize database creation using scripts.

If hardware matters I am running

Windows 2000 Server on a Pentium 600 with 786 MB of RAM
and Db version is 9.0.2
Thanks

Scott

Report message to a moderator

Re: Can I create more than one DB at the same time? [message #59919 is a reply to message #59915]

Sun, 04 January 2004 04:20

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

never tried it.
ideally, oracle needs a lot of swap space during installation ( at least 3xRAM).
But database creation is more looking into allocation of sga. I dont know memory allocation concepts in windows.
In unix the regular kernel parameters are set high enough, it is possible.
But i dont see the need for this, Unless u are going to create many many databases every day.!!
and a 786 MB of RAM is definatly not a high resource.
if u are planning to run multiple high use databases 
in the same machine plan for something bigger.

Report message to a moderator

Re: Can I create more than one DB at the same time? [message #59924 is a reply to message #59919]

Sun, 04 January 2004 07:15

scott
Messages: 73
Registered: September 1999

Member

Hello,
Just to give you all the outcome of my endeavour. It failed.Mid way through the process the entire system just shutdown for want of more memory. A SQL Server backup job was also running on the same machine.
This is my home machine and I decided to learn by experimentation.

My take on it. NEVER DO IT unless you have tonne of RAM and a very fast machine.

Thanks

Scott

Report message to a moderator

Re: Can I create more than one DB at the same time? [message #59981 is a reply to message #59915]

Wed, 07 January 2004 09:15

Sanjay
Messages: 236
Registered: July 2000

Senior Member

I have installed Oracle and created a database with a P2 400 and half gig memory (home comp). But was a very small db.

So I don't know how big of a database you were creating and more important, how many.

Good luck.

Report message to a moderator

Previous Topic:	ORA-00600:internal error
Next Topic:	Installation of 9.2.0.1.0

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 14 13:04:10 CST 2025