当前位置: 动力学知识库 > 问答 > 编程问答 >

statistics - 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!

网友答案:

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.

网友答案:

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.

分享给朋友:
您可能感兴趣的文章:
随机阅读: