Re: Oracle RecomendationSKIP
Date: 7 Jan 94 09:02:09 +1000
Message-ID: <1994Jan7.090209.1_at_cbr.hhcs.gov.au>
In article <daren.757798643_at_morgan>, daren_at_morgan.ucs.mun.ca (Daren Janes) writes:
> We have a requirement to build a database with one
> table having approximately 2 million rows. We will
> have 35,000 new inserts a month with lots of indexes
> on the table. The inserts will occur in chuncks of
> 50-100 records at a time. The database will have very
> little updating. There will be a maximum of 10 users
> logged into the system at any given time doing query
> type activity.
Either Oracle release should handle this quite easily.
>
> Should we go with Oracle 6 or 7?
> What Unix platforms should we consider?
Sorry, I'm on VAX/VMS. Somebody on a unix platform answer this one.
> How much of a DBA's time will this database chew up?
As much as you want to put into it. Oops that's a cop out 8^}.
A DBA doing minimal maintenance and support needs to:
- Backup the database and its archived logs regularly (can be automated but will have to spend some time automating it first)
- Regularly rebuild the indexes (can be very infrequent for low volatility database like this one). This keeps the indexes compact and fast. This can be automated as a script that extracts current index characteristics ,generates the creation scripts, and then drops all existing indexes and runs the creation script.
- Resize database objects to meet growth requirements (not crucial if you have a fixed size and cull rows to maintain this size). This can either be a export object, drop object, create new size object, and import object rows OR a full database export, drop database, create new database, and import full database. This can be time consuming but infrequent.
- Monitor database performance (not critical after initial examination of the application unless the application scripts are continually changing. However, if the 10 users are doing adhoc querries then you may have some very inefficient querries running and may need to constantly review your indexes for new ones needed or old ones to be superseded.
OK, now that I've scared you, let me say that all my experience todate has been on non-unix platforms but from what I've heard they are very similar.
I would say a minimal amount of work would be a few days a month.
>
> I realize that I have been very vague on the response
> time required but we are basically new to Unix and Oracle
> and just looking for suggestions from people running REAL!!
> databases with this technology.
>
>
> Daren Janes
> Memorial University of Newfoundland
> daren_at_morgan.ucs.mun.ca
Hope that helps.
-- Bruce... pihlab_at_cbr.hhcs.gov.au "If you swallow a live frog first thing in the morning ... Nothing worse will happen to either of you for the rest of the day." ******************************************************************* * Bruce Pihlamae -- Database Administration * * Commonwealth Department of * * Health, Housing, Local Government & Community Services * * Canberra, Australia (W) 06-289-7056 * ******************************************************************* * These are my own thoughts and opinions, few that I have. * *******************************************************************Received on Fri Jan 07 1994 - 00:02:09 CET