50,000 Users on an Oracle8 Universal Server Database
Tirthankar Lahiri, Ashok Josji, Amit Jasuja, Sumanta Chatterjee
Full Paper (PDF)

Slides (HTML)

Abstract
In this paper, we describe the Oracle Large User Population Demonstration and highlight the scalability mechanisms in the Oracle8 Universal Data Server which make it possible to support as many as 50,000 concurrent users on a single Oracle8 database without any middle-tier TP-monitor software. Supporting such large user populations requires many mechanisms for high concurrency and throughput. Algorithms in all areas of the server ranging from process and buffer management to SQL compilation and execution must be designed to be highly scalable. Efficient resource sharing mechanisms are required to prevent server-side resource requirements from growing unboundedly with the number of users. Parallel execution across multiple systems is necessary to allow user-population and throughput to scale beyond the restrictions of a single system. In addition to scalability, mechanisms for high availability, ease-of-use, and rich functionality are necessary for supporting complex user applications typical of realistic workloads. All mechanisms must be portable to a wide variety of installations ranging from desk-top systems to large scale enterprise servers and to a wide variety of operating systems.

References

References, where available, link to the DBLP on the World Wide Web.

[1]
William Bridge, Ashok Joshi, M. Keihl, Tirthankar Lahiri, Juan Loaiza, N. MacNaughton: The Oracle Universal Server Buffer. VLDB 1997: 590-594
[2]
Boris Klots: Cache Coherency in Oracle Parallel Server. VLDB 1996: 583
[3]
...
BIBTEX

@inproceedings{DBLP:conf/sigmod/LahiriJJC98,
author = {Tirthankar Lahiri and
Ashok Josji and
Amit Jasuja and
Sumanta Chatterjee},
editor = {Laura M. Haas and
Ashutosh Tiwary},
title = {50,000 Users on an Oracle8 Universal Server Database},
booktitle = {SIGMOD 1998, Proceedings ACM SIGMOD International Conference
on Management of Data, June 2-4, 1998, Seattle, Washington, USA},
publisher = {ACM Press},
year = {1998},
isbn = {0-89791-955-5},
pages = {528-530},
crossref = {DBLP:conf/sigmod/98},
bibsource = {DBLP, http://dblp.uni-trier.de}
}


DBLP: Copyright ©1999 by Michael Ley (ley@uni-trier.de).