How can I get the QPS or TPS of Oracle11g

Hi, All

My boss told me he wanted to know the QPS(Query Per Second) and TPS(Transaction Per Second) of current Oracle Database. The version is 11.2.0.3.
I found the TPS in the section of Load Profile of AWR report. But how can I get the QPS? I have the OEM12C. If it can provide the info, which page? THX
Best wishes!

Views: 392

▶ Reply to This

Replies to This Discussion

Permalink Reply by Verdell Biggers on July 25, 2013 at 9:46am

how will the QPS value be used once you have it?

does a query that returns a gazillion records have the same weight/value as a query that returns a single value?

Permalink Reply by Jared Perla on July 25, 2013 at 9:47am

This system contains various types of queries. Both a single value and a gazillion records will be counted into QPS.

Permalink Reply by Verdell Biggers on July 25, 2013 at 9:48am

QPS is a mythical indicator or performance

▶ Reply to Discussion

RSS

Oracle Jobs in US

Groups

Videos

  • Add Videos
  • View All

© 2024   Created by Maisam Agha.   Powered by

Badges  |  Report an Issue  |  Terms of Service