Re: Calculate DB requests/second?

From: Ross Mohan <rmohan_at_ix.netcom.com>
Date: Wed, 3 Feb 1999 10:40:35 -0500
Message-ID: <799qod$ll7$1@paxfeed.eni.net>

to get connections/sec:

look at the listener.log in $%TNS_ADMIN.

Set TRACE_LEVEL_LISTENER=USER in listener.ora

happy hunting.

Jeff Reineke wrote in message <01be4af9$7d550ab0$51630c8a_at_creinja-nt>...
>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 Wed Feb 03 1999 - 09:40:35 CST