sys@GHSJDB> select * from v$mystat where rownum=1;
? SID STATISTIC#? ? ? VALUE
----- ---------- ----------
? 247? ? ? ? ? 0 ##########
sys@GHSJDB> SELECT tracefile FROM v$process WHERE addr IN (SELECT paddr FROM v$session WHERE sid='247');
TRACEFILE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
/home/u01/app/oracle/diag/rdbms/ghsjdb/ghsjdb/trace/ghsjdb_ora_9481_10046.trc
5. 格式化输出tkprof
[oracle@server8 ~]$ tkprof
Usage: tkprof tracefile outputfile [explain= ] [table= ]
? ? ? ? ? ? ? [print= ] [insert= ] [sys= ] [sort= ]
? table=schema.tablename? Use 'schema.tablename' with 'explain=' option.
? explain=user/password? ? Connect to ORACLE and issue EXPLAIN PLAN.
? print=integer? ? List only the first 'integer' SQL statements.
? aggregate=yes|no
? insert=filename? List SQL statements and data inside INSERT statements.
? sys=no? ? ? ? ? TKPROF does not list SQL statements run as user SYS.
? record=filename? Record non-recursive statements found in the trace file.
? waits=yes|no? ? Record summary for any wait events found in the trace file.
? sort=option? ? ? Set of zero or more of the following sort options:
? ? prscnt? number of times parse was called
? ? prscpu? cpu time parsing
? ? prsela? elapsed time parsing
? ? prsdsk? number of disk reads during parse
? ? prsqry? number of buffers for consistent read during parse
? ? prscu? number of buffers for current read during parse
? ? prsmis? number of misses in library cache during parse
? ? execnt? number of execute was called
? ? execpu? cpu time spent executing
? ? exeela? elapsed time executing
? ? exedsk? number of disk reads during execute
? ? exeqry? number of buffers for consistent read during execute
? ? execu? number of buffers for current read during execute
? ? exerow? number of rows processed during execute
? ? exemis? number of library cache misses during execute
? ? fchcnt? number of times fetch was called
? ? fchcpu? cpu time spent fetching
? ? fchela? elapsed time fetching
? ? fchdsk? number of disk reads during fetch
? ? fchqry? number of buffers for consistent read during fetch
? ? fchcu? number of buffers for current read during fetch
? ? fchrow? number of rows fetched
? ? userid? userid of user that parsed the cursor
?
tkprof? /home/u01/app/oracle/diag/rdbms/ghsjdb/ghsjdb/trace/ghsjdb_ora_9481_10046.trc 10046.log sys=no
?
[oracle@server8 ~]$ more 10046.log
TKPROF: Release 11.2.0.3.0 - Development on Tue Feb 10 17:11:04 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates.? All rights reserved.
Trace file: /home/u01/app/oracle/diag/rdbms/ghsjdb/ghsjdb/trace/ghsjdb_ora_11266_10046.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
?
********************************************************************************
OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS
call? ? count? ? ? cpu? ? elapsed? ? ? disk? ? ? query? ? current? ? ? ? rows
------- ------? --------