High transaction rate Oracle DB 
Author Message
 High transaction rate Oracle DB

I am putting together an Oracle database with 500+ concurrent users with
8 large tables of
about 30 gigabytes.  The transaction rate against the 8 large tables
will be about 100 Oracle
transactions (one select,insert,update ordelete) per second.  Does this
sound like it can be done fairly easy?  Any hints?

Thanks



Tue, 05 Jun 2001 03:00:00 GMT
 High transaction rate Oracle DB

Tom-

Stuff like this ought never be characterized as "easy". But, with the
right design and implementation it is not unreasonable. You haven't told
us anything about the nature of the application, but I surmise that it
is OLTP. We don't know how much data will be hit at a time, nor do we
understand the patterns involved, like selectivity of index, sparsity,
etc. Were I on site, I would want to know about the hardware, memory,
nature of client, network type and topology, competing applications
(especially as it relates to network contention). How much logic will be
put on the server in the form of stored procedures and triggers? Is this
two-tier? Might there be a transaction processor involved?

What about skewing of key values? That can affect performance pretty
dramatically. Is the disk striped? Raid? Is this 24x7? Can you afford an
outage every week to do maintenance?

Anyway, there are a million issues involved, not the least of which have
more to do with the sql you run than how the instance is tuned. And if
you are new to Oracle, don't jump in the deep end without some serious
help. And no rookies on a big-gun, high visibility project.

But easy... naahhhh.

Roger

Roger Snowden
Sr. Systems Engineering Specialist
Oracle Corporation

Quote:

> I am putting together an Oracle database with 500+ concurrent users with
> 8 large tables of
> about 30 gigabytes.  The transaction rate against the 8 large tables
> will be about 100 Oracle
> transactions (one select,insert,update ordelete) per second.  Does this
> sound like it can be done fairly easy?  Any hints?

> Thanks



Wed, 06 Jun 2001 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. high db transaction rate

2. Server Problems due to High Transaction Rate

3. High TEMP tablespace IO rate

4. High parse rate for DBMS_JOB

5. US-IA Sybase System 10 DBA high rates long term

6. US-IA SYBASE10 DBA Long Term High rates

7. ***NYC: Sybase DBA w/ Replication Server - Contract/High Hourly Rates***

8. **NYC: Sybase DBA w/ Replication Server - Contract/High Hourly Rates**

9. NYC - Sybase DBA w/ Replication Server - Contract/High Hourly Rates

10. NYC: Sybase DBA w/ Replication Server - Contract/High Hourly Rates

11. US-IA Sybase DBA, long term, financial Client, High rates

12. US-IA Sybase DBA , Long term , high rates


 
Powered by phpBB® Forum Software