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: 347

Reply to This

Replies to This Discussion

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?

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

QPS is a mythical indicator or performance

Reply to Discussion

RSS

Oracle Jobs in US

© 2022   Created by Maisam Agha.   Powered by

Badges  |  Report an Issue  |  Terms of Service