Profiling in Oracle

[IonelBurtan]

Hi,
I am comming from MSSQL(3 years)

I am debugging a horde of COM compionents that are making a lot of Oracle database calls.
I was wondering how can I get the equivalent of Profiler from MSSQL in order to see ALL the queries that have run against the Oracle database in their order and with the coresponding duration and resource used.

I have looked at Top Session and Top Sql tools - but this does not satisfy the above needs (or I do not know how to tune it). I want to see ALL the queries, not the top ones.

Thanks,
Bye,

s-)

Blessed is he who in the name of justice and goodwill, sheperds the weak through the valley of darkness...

http://www20.brinkster.com/ionelb

 

[LKBrwnDBA]

You may need to set a trace and use tkprof to report the activity.

Set AUDIT_TRACE=DB in the init.ora parameters.

Set trace for a session:
ALTER SESSION SET SQL_TRACE=TRUE;




----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb