Re: Queries Per Second

"The Magnet" <art_at_unsu.com> wrote in message news:53f33ec8-0aa5-4e2a-9e9c-e2dcf3cfa681_at_a32g2000yqm.googlegroups.com...
>
> 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.

The answer to this question is not an easy one to pinpoint.

You could look at the statistic "user calls" - but a call could be parse / execute / fetch / commit / rollback. But if you are trying to assess network interaction this statistic may be the most appropriate even though it isn't exactly what you asked for.

You could look at the statistic "execute count" - but that includes calls to execute DML or pl/sql and not just queries, and it includes calls to execute recursive SQL so could be counting queries that do not travel across the network from the client to the server, but take place inside a pl/sql package, or event inside a pl/sql package called from an SQL statement.

If your Unix people can explain what metric they want to balance on, it may be possible to identify the best Oracle statistics to use.

-- 
Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html