Re: transaction simulation

How about something like the following - or would it break fairly soon with 'too manyfiles open'.

rem
rem repeater.sql
rem
rem Hack around with dbms_random and a little pl/sql rem to generate a random number of seconds

begin

    dbms_lock.sleep('random number of seconds') end;
/

_at_insert.sql

_at_repeater

--
Jonathan Lewis

Host to The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases
See http://www.jlcomp.demon.co.uk/book_rev.html

Seminars on getting the best out of Oracle
See http://www.jlcomp.demon.co.uk/seminar.html

Screensaver or Lifesaver: http://www.ud.com
Use spare CPU to assist in cancer research.




Daniel wrote in message ...


>Hi all:

>I'm trying to make a set of scripts to automate some inserts and

>deletes from tables to simulate a production database. I have a Bourne

>script who wakes up randomly and then calls to a sql script who make

>an insert or a delete.

>The call into the OS script is like "SQLPLUS / _at_insert.sql", but i

>dont want to connect every time i make a transaction. Can i send a sql

>script from a shell to a sqlplus session already running?... and how


>can i make it?.

>

>Thx in advance:

>  Dani