Re: creating a database

Amit Aggarwal wrote:
>
> Pete Desnoyers wrote:
> >
> > What would be considered the average length of time to create a
> > database? The reason I ask is that I issued the create database command
> > and all the files have been created; however, the command seems to be
> > hanging.
> >
> > Oracle: 7.3.2
> > OS: DEC UNIX 3.2
> >
> > --
> > >>>>>> Pete <<<<<<
> > http://jerry.engrs.infi.net
>
> It depends on how many datafiles you are creating and of what size. On
> an average, a database consisting of 5 datafiles each of 100M would take
> around 15-20 minutes. The command could have hung because of something
> else, which seems to be the case. So just make sure that your create
> database script is OK. and try ruuning it again after dropping the
> database and deleting all the OS files.
>
> amit
> Oracle DBA/Unix SA

I'm sorry but the performances you propose are very poor !

You should considerer 5 Mo / sec.
It makes 300 Mo / mn.

So 2 mn is totally enough on good hardware !!!

Hugues P.
France Received on Wed Sep 24 1997 - 00:00:00 CDT