Solved

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

Posted on 2011-09-06
6
253 Views
Last Modified: 2012-06-21
is there a way to find out all the queries which run against a table in a production environment?
0
Comment
Question by:Rao_S
  • 3
  • 2
6 Comments
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 125 total points
Comment Utility
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
 
LVL 73

Assisted Solution

by:sdstuber
sdstuber earned 375 total points
Comment Utility
with auditting on yes,  if not, no there isn't a reliable way to capture them all
0
 
LVL 73

Assisted Solution

by:sdstuber
sdstuber earned 375 total points
Comment Utility

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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:Rao_S
Comment Utility
after i run this:
AUDIT ALL ON schema1.table1;
how i find all sql that ran against the table?
0
 
LVL 73

Assisted Solution

by:sdstuber
sdstuber earned 375 total points
Comment Utility
look in dba_audit_trail or your adump directory

depends on your audit_trail parameter.
0
 

Author Closing Comment

by:Rao_S
Comment Utility
thank you....
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now