Hi guys, this is an extension to another question which is still being answered, and which led to me needing to know how to go about tracing the queries executed on an oracle db along with their times etc... all the info possible.
In MSSql we use SQL profiler to get all this, along with a nice history (that you can filter).
I guess my lack of experience with Oracle products leads me to this question.
What tools could one use for the job, where would I get them, and I have 10.2g I need to log as well as a new 12c I need to log. If a UI tool exists that would be nice, otherwise, if you will suggest text based or sqlplus based tools, please be thorough with links or description as to what to do to call up the needed app/command line.
I am from MSSQL world, please bear with me, due to a buyout I am needing to learn Oracle and do the switch. Thanks for all your patience! :)