How do I to find the insert rate?

From: Chin-Sim Kang <kang_at_cti.zko.dec.com>
Date: Fri, 24 May 2002 12:14:30 +0000 (UTC)
Message-ID: <aclar6$b9us$1@lead.zk3.dec.com>

Hi,

We are using Oracle 9.0.1 on Tru64 Unix 5.1 and running tests on our ODS. We have a test driver that does a large number of inserts in batches of 100 inserts at a time. The insert statement is only parsed once for each user. How do I find out what the insert rate is? Would it be captured in one of the v$ tables?

The idea is to create a custom chart in the Performance Manager so that a graphical representation of the insert rate can be displayed while the test is running. There is a chart in the Performance Manager that is labeled inserts. However, I found out that it gets it's data from the v$session table which counts the number of times the statment is parsed, in this case, once. Hence, it is of no use to us for our particular situation.

I would appreciate any help in trying to find out the insert rate using a simple SQL statement. Thanks in advance.

Chin-Sim Received on Fri May 24 2002 - 07:14:30 CDT