Re: Queries Per Second

From: The Magnet <art_at_unsu.com>
Date: Mon, 9 Nov 2009 10:13:55 -0800 (PST)
Message-ID: <1195ed91-93eb-4c59-b4aa-8dd5f40aaa3a_at_f16g2000yqm.googlegroups.com>



On Nov 9, 11:36 am, "Jonathan Lewis" <jonat..._at_jlcomp.demon.co.uk> wrote:
> "The Magnet" <a..._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 Lewishttp://jonathanlewis.wordpress.com
>
> Author: Cost Based Oracle: Fundamentalshttp://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
>
> The Co-operative Oracle Users' FAQhttp://www.jlcomp.demon.co.uk/faq/ind_faq.html

I took at look at the AWR previously but did not find anything. However, under the first section, Load Profile, there is an 'Executes' line item. Maybe that is the number of queries executed?? Received on Mon Nov 09 2009 - 12:13:55 CST

Original text of this message