Eine wenig bekannte aber interessante Option des TKPROFs ist „pdbtrace“.<\/p>\n\n\n\n
tkprof kann so die formatierte Ausgabe erzeugen ohne direkt Zugriff auf die Trace-Files auf Fileebene des Datenbank-Servers zu haben.<\/p>\n\n\n\n
–> Trace-Directory ermittlen<\/p>\n\n\n\n <\/p>\n\n\n\n Beispiel:<\/p>\n\n\n\n []$ more \/tmp\/tkprof_output.txt<\/strong><\/p>\n\n\n\n TKPROF: Release 19.0.0.0.0 – Development on Tue Apr 20 12:09:42 2021<\/p>\n\n\n\n Copyright (c) 1982, 2019, Oracle and\/or its affiliates. All rights reserved.<\/p>\n\n\n\n Trace file: CDB1_ora_11507_my_trace_id.trc count = number of times OCI procedure was executed SQL ID: 0g5n01r51t3f1 Plan Hash: 0<\/p>\n\n\n\n BEGIN DBMS_SESSION.SET_SQL_TRACE(sql_trace => true); END;<\/p>\n\n\n\n call count cpu elapsed disk query current rows Misses in library cache during parse: 0 SQL ID: ahc9t761kxw30 Plan Hash: 1388734953<\/p>\n\n\n\n select user call count cpu elapsed disk query current rows Eine wenig bekannte aber interessante Option des TKPROFs ist „pdbtrace“. tkprof kann so die formatierte Ausgabe erzeugen ohne direkt Zugriff auf die Trace-Files auf Fileebene des Datenbank-Servers zu haben. select value from v$diag_info where name=’Diag Trace‘; –> Trace-Directory ermittlen tkprof … Weiterlesen select value from v$diag_info where name='Diag Trace';<\/code><\/p>\n\n\n\ntkprof <input_tracefile> <output_textfile> <options> pdbtrace=<DB-user><password>\/@ora_connectstring<\/code><\/p>\n\n\n\nALTER SESSION SET TRACEFILE_IDENTIFIER = 'my_trace_id';<\/code><\/p>\n\n\n\nEXEC DBMS_SESSION.SET_SQL_TRACE(sql_trace => true)<\/code>;<\/p>\n\n\n\nselect user from dual;<\/code><\/p>\n\n\n\nEXEC DBMS_SESSION.SET_SQL_TRACE(sql_trace => false);<\/code><\/p>\n\n\n\ntkprof ..._my_trace_id.trc \/tmp\/tkprof_output.txt pdbtrace=...<\/code><\/p>\n\n\n\n
Sort options: default<\/p>\n\n\n\n
\n\n\n\n
cpu = cpu time in seconds executing
elapsed = elapsed time in seconds executing
disk = number of physical reads of buffers from disk
query = number of buffers gotten for consistent read
current = number of buffers gotten in current mode (usually for update)
rows = number of rows processed by the fetch or execute call<\/p>\n\n\n\n
\n\n\n\n
——- —— ——– ———- ———- ———- ———- ———-
Parse 0 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 2 184 0 1
Fetch 0 0.00 0.00 0 0 0 0
——- —— ——– ———- ———- ———- ———- ———-
total 1 0.00 0.00 2 184 0 1<\/p>\n\n\n\n
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: SYS<\/p>\n\n\n\n
\n\n\n\n
from
dual<\/p>\n\n\n\n
——- —— ——– ———- ———- ———- ———- ———-
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 2 0.00 0.00 0 0 0 1
——- —— ——– ———- ———- ———- ———- ———-
total 4 0.00 0.00 0 0 0 1<\/p>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"