eygle.com - 留言簿 - 回复留言

eygle.com - 留言簿 - 回复留言 - Powered by eYgLe.Com

返回留言簿

回复留言

留言ID:

留言原文:

To: eygle
　　exec dbms_system.set_sql_trace_in_session
做的报告怎么没有执行计划呢？

SQL> alter session set sql_trace=true ;
会话已更改。
SQL> exec dbms_system.set_sql_trace_in_session(9,37,true);
PL/SQL 过程已成功完成。
SQL> exec dbms_system.set_sql_trace_in_session(9,37,false)
PL/SQL 过程已成功完成。
SQL>

tkprof 'D:\Oracle\admin\oradb\udump\oradb_ora_1040.TRC' 'd:\aaaag.txt'

报告如下：

TKPROF: Release 9.2.0.1.0 - Production on 星期六 7月 9 22:45:50 2005

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

Trace file: D:\Oracle\admin\oradb\udump\oradb_ora_1040.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
********************************************************************************

select *
from
t_mz_sf

call count cpuelapsed diskquerycurrentrows
------- -------------- ---------- ---------- ---------- --------------------
Parse10.00 0.00000 0
Execute10.00 0.00000 0
Fetch10.00 0.00030 0
------- -------------- ---------- ---------- ---------- --------------------
total30.00 0.00030 0

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 62

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

OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS

call count cpuelapsed diskquerycurrentrows
------- -------------- ---------- ---------- ---------- --------------------
Parse10.00 0.00000 0
Execute10.00 0.00000 0
Fetch10.00 0.00030 0
------- -------------- ---------- ---------- ---------- --------------------
total30.00 0.00030 0

Misses in library cache during parse: 0

OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS

call count cpuelapsed diskquerycurrentrows
------- -------------- ---------- ---------- ---------- --------------------
Parse00.00 0.00000 0
Execute00.00 0.00000 0
Fetch00.00 0.00000 0
------- -------------- ---------- ---------- ---------- --------------------
total00.00 0.00000 0

Misses in library cache during parse: 0

 1userSQL statements in session.
 0internal SQL statements in session.
 1SQL statements in session.
********************************************************************************
Trace file: D:\Oracle\admin\oradb\udump\oradb_ora_1040.TRC
Trace file compatibility: 9.00.01
Sort options: default

0session in tracefile.
1userSQL statements in trace file.
0internal SQL statements in trace file.
1SQL statements in trace file.
1unique SQL statements in trace file.
8lines in trace file.

From: John
2005.07.09 07:56