Your original question was on time difference in creating the two databases.
I may be wrong but possibly the first database was cloned from a sample
database on the CD while the second one was actually "created" and includes
the time for running various scripts, catproc etc.
"Vu Pham" <vu_at_sivell.com> wrote in message
news:c0jlgc$18kl9l$1_at_ID-219297.news.uni-berlin.de...
>
> "Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
> news:1076711322.369865_at_yasure...
> > Vu Pham wrote:
> >
> > > Thanks.
> > > Yes, this is the second one. The first one is the one I created when
> > > installing Oracle in the first place.. I am new to Oracle and just try
> to
> > > see how it works.
> > >
> > > Btw, then if I have two different projects, is it not better to have a
> 2nd
> > > database ?
> > > Again, sorry if I ask some funny question.
> > >
> > > Vu
> >
> > There is almost no reason in Oracle to ever build a second database.
> > What you are doing is doubling the overhead with hardly a single bit
> > of value in return: Two SYSTEM tablespaces, to UNDO tablespaces, two
> > TEMP tablespaces, two SGAs.
> >
> > Creates new tablespaces and users. Before creating a second database
> > you need a compelling reason based on an actual failure of a single
> > database to meet your requirement (extremely rare). Keep in mind, as
> > Sybrand would say, that Oracle is not SQL Server and you can't treat
> > it as though it is.
> >
> Thanks, Daniel. Now I see why the 2nd database takes so long to finish. I
> ran top to watch the system resource and did see a lot resources have
being
> used by the first instance.
>
> Vu
>
>
Received on Sat Feb 21 2004 - 13:02:29 CST
