Rob, What would you like to do with your install? If you want to just 'play around' then the default install is really just fine. If you want to run a web site or a transactional system with just a few users (something like a web site for this list), then the default install is just fine. If, on the other hand, you want to run a high volume transactional application or high volume web site then my recommendation would be to stop by your favorite book store and pick up a book on tuning Oracle. Oracle has a LOT of different little knobs and buttons that can really make a big difference in performance, but like any large project (linux anyone?) it will take a little research to learn what is best for your environment. Some VERY basics: Look at your init.ora file (might be named something like initORCL.ora). There are some basic ways to tune Oracle in there. You will notice things like buffer sizes, shared memory size (SGA), and other parameters that you can tune. Generally giving Oracle more memory to work with will help things quite a bit. Separating tablespaces between different disks can also help because Oracle, like any database product, is going to have pretty large disk I/O requirements in a high volume environment. <Advertisement> If you want to play around with a pretty cool product, take a look at WebDB 2.2 which is available for Linux on http://otn.oracle.com. It is a tool that 'web enables' the database quickly and easily. It has browser based wizards for building simple web applications, and self service content areas for uploading and managing content. For example building a web site where everyone in this mail list could upload beer recipes (to pull from another topic on the list) would take about 30 minutes and would require no code writing. (I could actually do it in less than 10, but I have a slight advantage...). Just a FYI: There is a newer version of the Oracle Database for Linux, Oracle 8.1.6. It is also available on technet (http://otn.oracle.com). By the end of the year Oracle's new Application Server (which is Apache based) will also be available for Linux. It will contain a new version of WebDB which has been renamed Oracle Portal. Look for Oracle9i Application Server for Linux. </Advertisement> [Just so everyone knows, I am a Principal Product Manager in Portal Development at Oracle. WebDB and Oracle Portal are 'my' products, which is why I gave them plugs here.] Good Luck! Rich -- Richard Soule Principal Product Manager, Portal Development 650.506.4563 [EMAIL PROTECTED] Rob Yelle wrote: > > I have installed Oracle (8.0.5) for linux on a red hat 5.2 machine > today. (scott tiger ) > Can I get some feed back from others who have done the same. > I wanted to here what others (DBA types) have done to tune the custom > install VS going the default route. > > Rob from no.weare > > ********************************************************** > To unsubscribe from this list, send mail to > [EMAIL PROTECTED] with the following text in the > *body* (*not* the subject line) of the letter: > unsubscribe gnhlug > **********************************************************
begin:vcard n:;Richard x-mozilla-html:FALSE adr:;;;;;; version:2.1 email;internet:[EMAIL PROTECTED] fn:Richard Soule end:vcard
