SAP Note 654176 - Analyzing Oracle trace files with TKPROF

Composant : Oracle -

Solution : https://service.sap.com/sap/support/notes/654176 (Connexion à SAP Service Marketplace requise)

Mots Clés :
run schedule rows     row source operation-------  ---------------------------------------------------      1  sort aggregate 494592   index full scan tablarge~1, call    count    cpu elapsed    disk   query current     rows------- -----  ----- ------- ------- ------- -------  -------parse       1   0, tkprof <trace_file> <output_file> [explain=<user>/<pwd>]        [sort=<sort_criteria>] [print=<number>] [sys=, wait total waited  ---------------------------- waited ---------- ------------  sql net message, output file explain=<user>/<pwd>, txt sort=fchrow print=1 aggregate=, explain schedules sort=<sort_criteria>, elapsed times include waiting, <number> sql statements sys=, aggregated sql statements sorted chronologically

Notes associées :

613872Oracle traces with ORADEBUG