Re: Help setting up an Oracle DB

Hi Tony,

    Create one Oracle instance with several tablespaces (what you are calling a database). You should have separate tablespaces for:

     System tables (default name is SYSTEM),     Temporary tables Oracle uses for sorting, etc (default name is TEMPORARY),
    Rollback segments (default name is RBS),     Oracle and 3rd party tools (default name is TOOLS),     Development user work space (default name is USERS),     Production data (one or more tablespaces depending on nature of apps),     Index data (one or more tablespaces depending on nature of apps).

If you want performance each of the above should be on a separate disk drive and, depending on the nature of the application you may want more than one drive for both data and indexes.

regards

Jerry

Tony Johnston wrote in message <36ceca16.64109149_at_news.mindspring.com>...
> I'm in the beginning stages of converting a payroll system to Borland
>C++ Builder 4 with an Orale database. The payroll system right now
>has 66 different data files. How would I get the best performance
>settiing up the database. What I mean would it be beneficial to
>create one database with 66 tables in it or split it out. The total
>size of all current files can range from anywhere between 11 megs to
>50 megs in size. The application is being designed as a multi-tier
>intranet application. Will one database file containing all these
>tables create to much drag on the system and inhibate performance?
>I would appreciate any opinions on this.
>
>Thanks,
> Tony
Received on Mon Feb 22 1999 - 07:45:16 CST