Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 262
  • 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
Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

 
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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

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