SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Queries Per Second

Nimish GargFeb 10 2011 — edited Feb 11 2011

Is there any why to get the number of queries per second on oracle database.
more specifically i want result like this

Number of Select statements per second:
Number of Insert statements per second:
Number of Update statements per second:
Number of Delete statements per second:

my database is

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Release 10.2.0.4.0 - 64bit Production
PL/SQL Release 10.2.0.4.0 - Production
CORE    10.2.0.4.0      Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 11 2011

Added on Feb 10 2011

13 comments

3,115 views