SQL tracing for application
mradul goyal, October 12, 2015 - 11:06 am UTC
Hi chris,
Thanks for reply.
I am not doing this to improve my skill but if i will not do this then i will not get paid and i want to say that if i do this exercise then it will improve my skills in database performance tuning as i do not have much exposure to database administration activity but have experience in PLSQL and SQL not much but of 1 years.
I will do this first on out test env. then afterwards if things will be okey move to production only.
However for alternate solution i discussed with my boss that i have figure out some tables using DBMS_ADVISOR which you help me out in my previous question but he says that it is little amount of information we not to dig more into out database so i come up with this IDEA !
So my basic need here is to trace all the SQL's used by an application for some amount of time say 1 hrs. For this we have a tool which automatically fire orders and can fire 100 orders in 5 minutes so if i can get all the SQL's for this 5 minutes then i can move forward woth my plan and can make a report like
>which filters are mostly used in the WHERE clause
>Which tables are frequently used for SELECT Statement
>Which tables are frequently used for UPDATE Statement
>Which tables are frequently used for DELETE Statement
like that.
So my basic requirement is to track all the SQL's used by the application.