Re: Advice: Creating new Oracle DB

I would like to know which OS (i'm assuming NT due to the relatively small size..but 3.51 or 4.0...and is the DB's main function OLTP?) you have it running on, but despite, my advice to you is this:

Oracle is full of configurations. It is what it is known for. However, the Oracle DB Engineers have chosen some unlikely (even downright idiotic) default settings. Make sure you have a full understanding of each configuration setting. Look up a listing of all the defaults because you may find, in many cases, that the default is exactly what you don't want and may cause/rather will cause serious performance problems. It would probably be extremely useful, if you do not have a senior ORACLE DBA on staff, to have one come in and help configure your INIT.ora file (or take the ORACLE DBA or TUNING class at ORACLE corp...the Oracle Press books are also pretty good if you have time to peruse them). You also want to spend time estimating what your database's maxed out/bloated capacity is in order to analyze initial storage for your tablespaces, etc...

Laurie

-- 
+-------------------------------------+-----------------------------+
| Laurie J. Kirsh                     | Oracle DBA/Design/Developer |
| lkirsh_at_itsc.org  			  | Integration Systems Analyst |
| Lockheed Martin                     | ITSC project                |
| 301-982-1113				  | College Park, Maryland      |
+-------------------------------------------------------------------+
Opinions are mine and do not necessarily reflect those of 
Lockheed Martin Corporation.

CDWaddell <cdwaddell_at_aol.com> wrote in article
<19970523161801.MAA01168_at_ladder01.news.aol.com>...


> Hi,

> 

> I'm in the process of creating a new Oracle 7.3 database, my first one,

> and am wondering if there is anything I should know in advance abuot the

> DB creation process.  Is there anything that may come back and haunt me

 if


> I'm to leave something out in the creation?  Are there any serious

> performance issues that I should be aware of durring the creation so I

 can


> include them now so they don't nip me in the butt later?

> 

> We are converting things from a fairly large paradox database (aprox.

> 1.5gb) into Oracle 7.3 workgroup server.  Should I be carefull about the

> tablespaces, rollback segments, extents and so on so that I will not run

> into trouble later.  

> 

> ANY HELP OR COMMENTS ARE APPRECIATED!

> 

> Thanks in advance.

> 

> Cary D. Waddell

> CDWaddell_at_AOL.COM

> MHS, Inc. Denver, CO

>