Queries Per Second

The Magnet

unread,

Nov 9, 2009, 11:13:26 AM11/9/09

to

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.

Gerard H. Pille

unread,

Nov 9, 2009, 12:06:07 PM11/9/09

to

The Magnet wrote:
>
> I'm looking over OTN& Metalink. We're looking for a way to see if we

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.

Jonathan Lewis

unread,

Nov 9, 2009, 12:36:47 PM11/9/09

to

"The Magnet" <a...@unsu.com> wrote in message
news:53f33ec8-0aa5-4e2a...@a32g2000yqm.googlegroups.com...

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

The Magnet

unread,

Nov 9, 2009, 1:13:55 PM11/9/09

to

On Nov 9, 11:36 am, "Jonathan Lewis" <jonat...@jlcomp.demon.co.uk>
wrote:

> 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??

Jack

unread,

Nov 9, 2009, 1:18:02 PM11/9/09

to

What kind of numbers others have, we have 7 TeraBits

What would be reosonable I/O per day? (1GB NIC)
(Reosonable=trouble free)

"The Magnet" <a...@unsu.com> kirjoitti
viestiss�:53f33ec8-0aa5-4e2a...@a32g2000yqm.googlegroups.com...

Jack

unread,

Nov 13, 2009, 11:44:06 AM11/13/09

to

Any other values?
That 7 is just lucky number during many days ;)

"Jack" <Ja...@none.com> kirjoitti
viestiss�:4af85cde$0$6279$9b53...@news.fv.fi...