I was given the task of comparing the new 12c to our older 10.2g setup.
I come from a MS Sql env. and find the lack of tools to do what I could do in MS SQL inexplicable. I am sure it must be because I am unaware of the tools themselves and not because they don't exist.
The goal is to find out why on 2 separate vms running windows 2008R2, same amount of disk space and ram, with one instance 10.2g and the other with 12c, running the same jobs to build cubes at night, why the 12c is 2 times longer then the 10.2g to run.
I know it sounds vague, but the dbs out of the box configs of both machines should make the 12c faster then 10.2g (or so I am led to believe). as there are no other jobs/apps running on those machines (it was setup just exactly for this scenario).
My concern though is the possibility of wasting time to analyze #2 below when maybe just changing a small default parameter (that may have changed in 12c) could return the times to almost the same (#1). Here are the questions I need answered if possible.
1) Out of the box, what parameters specifically could Oracle have modified from 12c to 10.2g that could lead to such a decrease in performance, and
2) I need a MS SQL Profiler equivalent that will allow me to sit back and log all the queries and times that runs on a machine (like SQLProfiler) and just get an output of times for each query. SQLProfiler could allow me to cut and paste into Enterprise manager the query then get an execution plan for it, it would be nice to know how to do this as well in Oracle.
Please excuse the lack of knowledge when it comes to Oracle, but was dba for MS and had to turn a new leaf due to company policy of switching to Oracle backends when we changed ownership.