thanks for the info. this is strictly a test database for learning. i
agree with your file placement suggestions. i currently work with IMS &
DB2, so Oracle is new to me.
"Dusan Bolek" <pagesflames_at_usa.net> wrote in message
news:1e8276d6.0111150053.59585a9e_at_posting.google.com...
> "Gary Turner" <gary.turner_at_sci.com> wrote in message
news:<E5BI7.35354$lV4.4260535_at_e420r-atl1.usenetserver.com>...
> > i created a new database and here is the init.ora file it created:
> >
> > also i have the creatdb.log at the bottom. is the all i need to look at
or
> > are there other things i need to check???
> <Snipped>
>
> You didn't mention the purpose of this database. However, your
> createdb.log together with init.ora doesn't make a sense to me.
> If this is just databse for same testing or learning Oracle, then your
> SGA size is far too big. If this should be a productional database
> (and I hope not !) then using only one tablespace and not mirroring
> your redo logs is asking for troubles. Having all control files on one
> drive is also extremely bad. Running database in NOARCHIVELOG is
> another usually not suitable solution.
> Another thing is parameter "compatible = 8.1.0", if you're using 8.1.0
> version then you should upgrade to 8.1.7.2, if you have newer version
> than 8.1.0, then there is usually no need to downgrade this parameter.
>
> --
> _________________________________________
>
> Dusan Bolek, Ing.
> Oracle team leader
>
> Note: pagesflames_at_usa.net has been cancelled due to changes (maybe we
> can call it an overture to bankruptcy) on that server. I'm still using
> this email to prevent SPAM. Maybe one day I will change it and have a
> proper mail even for news, but right now I can be reached by this
> email.
Received on Thu Nov 15 2001 - 10:07:33 CST
