Hi Experts,
i had enabled a 1403 system wide trace event and it generated a 7.8 GB trace file -
but while generating the tkprof , the output file is giving very few details -
[oracle@xxxxxxx trace]$ ls -lhrt DHHDR1_ora_18805.trc
-rw-r----- 1 oracle asmadmin 7.8G Dec 27 23:21 DHHDR1_ora_18805.trc
[oracle@xxxxxxx trace]$
[oracle@xxxxxxx trace]$ tkprof DHHDR1_ora_18805.trc DHHDR1_ora_18805.txt
TKPROF: Release 12.1.0.2.0 - Development on Wed Dec 28 14:58:15 2016
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
[oracle@xxxxxxx trace]$ ls -lhrt DHHDR1_ora_18805.txt
-rw-r--r-- 1 oracle oinstall 1.2K Dec 28 14:58 DHHDR1_ora_18805.txt
[oracle@xxxxxxx trace]$
[oracle@xxxxxxx trace]$ cat DHHDR1_ora_18805.txt
TKPROF: Release 12.1.0.2.0 - Development on Wed Dec 28 14:58:15 2016
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
Trace file: DHHDR1_ora_18805.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: DHHDR1_ora_18805.trc
Trace file compatibility: 11.1.0.7
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.
217102539 lines in trace file.
0 elapsed seconds in trace file.
[oracle@xxxxxxx trace]$
Please advice me
Thanks in advance
Mahi