Path: utzoo!attcan!uunet!mcvax!hp4nl!4gl!honzo From: honzo@4gl.UUCP (Honzo Svasek) Newsgroups: comp.databases Subject: Re: Oracle Peformance Simulation Message-ID: <557@4gl.UUCP> Date: 20 Nov 88 11:58:44 GMT References: <3352@newton.praxis.co.uk> Organization: 4GL Consultants b.v., the Netherlands Lines: 42 From article <3352@newton.praxis.co.uk>, by ben@praxis.co.uk (Ben Dillistone): > I am in the process of trying to create a performance evaluation > environment for an interactive/batch Oracle system. . . . > The problem is simulating variable numbers of users. > The only solution so far is to use a script repeatedly running SQL*Forms > with an pre-created echo file generating the key strokes. A single such > script generates about 150 queries a minute on a MicroVAX (can you type > that fast?). I have worked on a simular simulation for Unify/Accell on Unisys hardware. We started of the way you describe. It gave some idea of the speed of the machine for this application, but was not really realistic. After quite some experimenting, we ended up with a system that used pty's and some sort of feedback. Two programs talking to the master end of the pty. A writer program (the hands of the typist) and a reader program (the eyes of the typist). The writer 'types' the keystrokes for one transaction and sleeps. The reader reads the 'screen' until it recognises a token on the screen that indicates that the transaction is now processed. It then waits some seconds ('thinks'), and then wakes the writer up with a user signal. The actual benchmark was developed from scratch for my client, and I doubt that they are willing to make it available. The reader/writer part was developed be me and based on comp.sources programs. I guess this makes it public domain :) If there is a lot of interest for it I will post it AS IT IS. This means that you will have to change some things to make it work for you. For instance: it has vt220 keys hard coded in! If there is not a lot of interest, I will mail it... just let me know. I_I( _ I I ) Honzo Svasek --------------------------------------------------- Svasek Software Consultants - - - - - > Uniconsult IJsselkade 24, 3401 RC IJsselstein, the Netherlands ---------------------------------------------------