Re: Queries Per Second

From: Gerard H. Pille <>
Date: Mon, 09 Nov 2009 18:06:07 +0100
Message-ID: <4af84bff$0$2846$>

The Magnet wrote:
> I'm looking over OTN& Metalink. We're looking for a way to see if we
> can capture how many queries per second are submitted to Oracle.
> Whether or not the get a cache hit is not important, just the number
> per second. Out Unix guys are setting up some sort of load balancer
> and want to know this.
> We're on 10.2 on a Linux platform. Does Oracle provide any of this?
> Maybe something that shows it in a different interval and we can get
> an average?
> Sys Admins always want the world.

You should already have this information in your database. Google for AWR, automatic workload reports (or is it repository). Normally, you should have a snapshot every hour. Received on Mon Nov 09 2009 - 11:06:07 CST

Original text of this message