How to get the start time and duration of the SQL-queries to the specified tables in the database (Oracle 10g)? I need information even about very short queries, which can be many, and which AWR not shows.
Asked
Active
Viewed 155 times
1 Answers
0
Why do you need such diagnostic? It's possible to turn on tracing for each user/session but I wouldn't recommend that since the DB will spend more resources on tracing than on the actual work.
Alen Oblak
- 3,285
- 13
- 27