Computing Publications

Publications Home » A queueing network model of Oracl...

A queueing network model of Oracle Parallel Server

Uli Harder, Peter G. Harrison

National Workshop Paper
UKPEW 1999
July, 1999
ISBN 0-9524027-8-5

An approach to modelling an Oracle database is presented for both single instance and parallel server versions. A modified queueing network is used which is extended to include traditional transaction locks which achieve serialisation and the new PCM locks of Oracle which ensure coherency in the distributed database buffers. The latter are not enqueue locks and so require different techniques. Both locks require an iterative solution to a fixed point model. The numerical results produced by the model can be validated largely

using data maintained in Oracle tables and the distributed lock manager, and we identify the relevant entries.

PDF of full publication (130 kilobytes)
(need help viewing PDF files?)
Postscript of full publication (503 kilobytes)
(need help viewing Postscript files?)
BibTEX file for the publication
Conditions for downloading publications from this site. built & maintained by Ashok Argent-Katwala.