0
votes
0answers
47 views

Which queries are running and what tables are they accessing? [duplicate]

I am learning Oracle. I am trying to write a query to find out the list of SQL queries and the tables that they access. I tried looking into v$sql, v$sqlarea etc, but was not able to find a column ...
1
vote
2answers
1k views

How to find DELETE and UPDATE statements that have been executed on a database?

I am trying to find out what delete and update statements have been executed on a certain database in a certain period of time. I came across this following query, but it generates an error message: ...
1
vote
1answer
130 views

The best way to log access to SSRS reports

We have a number of SSRS reports created using BIDS 2008 on SQL Server 2008 r2. The business wants us to log access to these reports. For example who and when run the Report A. What is the best way ...
2
votes
1answer
369 views

Disabling Indexes and Auditing for large data import

Hopefully the title describes this sufficiently, but I have a process that runs and performs thousands of individual inserts and updates (nothing I can do to change that). My questions are: 1. Is it ...