¡¾Ñ§Ï°Ìù¡¿Oracle×ܽá+++

/*============================================================================
*Author: MartriWang@gmail.com
*Date: 09/05/2007
*Description:ORACLE Summary
*==========================================================================*/

»ã×Ü£º
set autotrace on
set autotrace traceonly explain
set timing on

»òͨ¹ýSQL*PLUS trace£¬È»ºó²é¿´user_dump_destϵĸú×ÙÎļþ£¬Ê¹ÓÃtkprof¹¤¾ß¸ñʽ»¯ºóÔÄÀÀ¡£
alter session set events '10046 trace name context forever,level 12';
alter session set events '10046 trace name context off';
SELECT p.spid,s.username from v$session s,v$process p WHERE s.audsid=USERENV('sessionid') AND s.paddr = p.addr;

ʹÓ÷½·¨Ê¾Àý£º
DBserver% sqlplus perf/perf
SQL*Plus: Release 9.2.0.6.0 - Production on Mon Oct 17 14:32:29 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
SQL> set timing on
SQL> set autotrace on
SQL> select count(*) from perf_sdcch_nn where start_time = (select max(start_time) from perf_sdcch_nn);
COUNT(*)
----------
638
Elapsed: 00:00:00.80
Execution Plan
----------------------------------------------------------
0 SELECT STATEMENT Optimizer=CHOOSE (Cost=1 Card=1 Bytes=8)
1 0