TKProf Simplistic Overview

Example Output (Partial) File
-----------------------------

TKPROF: Release 7.2.2.3.0 - Production on Wed Aug 7 11:29:43 1996

Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.

Trace file: .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
********************************************************************************

DELETE FROM RM$HASH_ELMS

call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 2 0.00 0.00 0 0 0 0
Execute 29 12.04 12.61 6786 6853 108 19
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 31 12.04 12.61 6786 6853 108 19
[@more@]

Subject:	TKProf Simplistic Overview
	Doc ID:	Note:41634.1	Type:	REFERENCE
	Last Revision Date:	17-JUL-2006	Status:	PUBLISHED

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/190276/viewspace-902938/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/190276/viewspace-902938/