Hi Team,
We had few queries running slow in DB so we had generated 10053 trace for those queries and it generated successfully. But while running tkprof utility against those files the out out file is not showing any thing except below heading . Could you please help me how to read 10053 trace file using tkprof utility.
TKPROF: Release 19.0.0.0.0 - Development on Mon Jul 3 10:38:55 2023
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Trace file: jira_ora_13188_10053_trace2.trc
Sort options: default
********************************************************************************
count = number of times OCI procedure was executed
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
********************************************************************************
Trace file: jira_ora_13188_10053_trace2.trc
Trace file compatibility: 12.2.0.0
Sort options: default
1 session in tracefile.
0 user SQL statements in trace file.
0 internal SQL statements in trace file.
0 SQL statements in trace file.
0 unique SQL statements in trace file.
5675923 lines in trace file.
0 elapsed seconds in trace file.
Thanks,
Debasis