ORA-01555错误浅析(3)

核心提示： TKPROF: Release 9.2.0.5.0 - Production on Tue Mar 14 09:21:58 2006Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.Trace file: p

TKPROF: Release 9.2.0.5.0 - Production on Tue Mar 14 09:21:58 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

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

********************************************************************************

alter session set events='10046 trace name context forever, level 1'

... ...

BEGIN

ext_pkg.main('extfiles','50','EAT');

END;

call count cpu elapsed disk query current rows

------- ------ -------- ---------- ---------- ---------- ---------- ----------

Parse 1 0.01 0.04 4 39 0 0

Execute 1 0.20 0.21 24560 37808 0 1

Fetch 0 0.00 0.00 0 0 0 0

------- ------ -------- ---------- ---------- ---------- ---------- ----------

total 2 0.21 0.26 24564 37847 0 1

Misses in library cache during parse: 1