问题描述:

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.

相关阅读:
Top