Re: Calculate DB requests/second?

Hi Jeff,

Run utlbstat at say 09:00 and utlestat at 13:00. This will produce a report with the information you want
both scripts are located in $ORACLE_HOME/rdbms/admin and need to be run by svrmgr.
As you didn't specify your platform I'm not able to provide the exact commands.

Hth,

Sybrand Bakker, Oracle DBA

Jeff Reineke wrote:

> Does anyone have a calculation for determining the number of database
> requests per second that an Oracle instance is performing over a period of
> time? It sounds simple but I'm having trouble getting this information.
> As a matter of fact, how can I determine the total number of requests (of
> all types - select, insert, update, delete) over a period of time?
>
> Your help is much appreciated.
>
> Jeff

Received on Fri Jan 29 1999 - 03:54:54 CST