CODEWITHSUNDEEP
oracle-databasestatisticsoracle11g
daveslab
daveslab

Reputation: 10310

How to see number of total queries made to Oracle over time period?

I have a simple need: I need to see how many queries a vendor's application is running against our Oracle (11g r2) database. Is there a way to query a system table (e.g. v$...) to see this information?

Thanks!

Upvotes: 1

Views: 2381

Answers (2)

Chip Dawes
Chip Dawes

Reputation: 26

v$SQL has some stats and can tell you module and action (see dbms_application_info) v$SQLSTATS has more statistics but less ability to determine application source.

DBAs can be overly protective and take the easy way out banning access to really useful stuff. See if a view (that masks sensitive info) can be created and granted to you so you have access to the really useful stuff while not to the sensitive stuff.

Upvotes: 0

DCookie
DCookie

Reputation: 43533

Have you looked at V$SQLSTATS? I'm not sure how you're going to differentiate the vendor-specific SQL from other SQL that might have run, but this could give you a feel for what has been running.

If all you're interested in is what's happening now, then perhaps V$SQLAREA is what you want.

Upvotes: 1

Related Questions