Re: Queries Per Second
From: Gerard H. Pille <ghp_at_skynet.be>
Date: Mon, 09 Nov 2009 18:06:07 +0100
Message-ID: <4af84bff$0$2846$ba620e4c_at_news.skynet.be>
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.
Date: Mon, 09 Nov 2009 18:06:07 +0100
Message-ID: <4af84bff$0$2846$ba620e4c_at_news.skynet.be>
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