[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 264
  • Last Modified:

Can we find all queries which run against a production table?

is there a way to find out all the queries which run against a table in a production environment?
0
Rao_S
Asked:
Rao_S
  • 3
  • 2
4 Solutions
 
slightwv (䄆 Netminder) Commented:
If you have auditing turned on.

If you do not, you can scan the SQL in memory but you will lose past SQL that has been flushed.

What are you looking to do?
0
 
sdstuberCommented:
with auditting on yes,  if not, no there isn't a reliable way to capture them all
0
 
sdstuberCommented:

simple example to catpure all activity for a table...

audit all on YOURSCHEMA.YOURTABLE


for more info...

http://download.oracle.com/docs/cd/E11882_01/server.112/e17118/statements_4007.htm#i2059073
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
Rao_SAuthor Commented:
after i run this:
AUDIT ALL ON schema1.table1;
how i find all sql that ran against the table?
0
 
sdstuberCommented:
look in dba_audit_trail or your adump directory

depends on your audit_trail parameter.
0
 
Rao_SAuthor Commented:
thank you....
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now