ʹÓà Tkprof ·ÖÎö ORACLE ¸ú×ÙÎļþ
TkprofÊÇÒ»¸öÓÃÓÚ·ÖÎöOracle¸ú×ÙÎļþ²¢ÇÒ²úÉúÒ»¸ö¸ü¼ÓÇåÎúºÏÀíµÄÊä³ö½á¹ûµÄ¿ÉÖ´Ðй¤¾ß¡£Èç¹ûÒ»¸öϵͳµÄÖ´ÐÐЧÂʱȽϵͣ¬Ò»¸ö±È½ÏºÃµÄ·½·¨ÊÇͨ¹ý¸ú×ÙÓû§µÄ»á»°²¢ÇÒʹÓÃTkprof¹¤¾ßʹÓÃÅÅÐò¹¦Äܸñʽ»¯Êä³ö£¬´Ó¶øÕÒ³öÓÐÎÊÌâµÄSQLÓï¾ä¡£
Ò». TKPROF ÃüÁîÓï·¨£º
TKPROF filename1, filename2 [ SORT = [ opion][,option] ]
[ PRINT = integer ]
[ AGGREGATE = [ YES | NO ] ]
[ INSERT = filename3 ]
[ SYS = [ YES | NO ] ]
[ [ TABLE = schema.table ] | [ EXPLAIN = user/password ] ]
[ RECORD = filename ]
Ïà¹Ø˵Ã÷£º
filename1 Ö¸¶¨µÄÊäÈëÎļþ£¬¿ÉÒÔÊǶà¸öÎļþÁªÆðÀ´¡£
Filename2 ¸ñʽ»¯Êä³öÎļþ¡£
SORT ÔÚÊä³öµ½Êä³öÎļþÇ°£¬ÏȽø³ÌÅÅÐò¡£Èç¹ûÊ¡È¥£¬Ôò°´ÕÕʵ¼ÊʹÓõÄ˳ÐòÊä³öµ½ÎļþÖС£ÅÅÐòÑ¡ÏîÓÐÒÔ϶àÖÖ£º
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 
Ïà¹ØÎĵµ£º
£¨1£©[Q]ÈçºÎ²åÈëµ¥ÒýºÅµ½Êý¾Ý¿â±íÖÐ
[A]¿ÉÒÔÓÃASCIIÂë´¦Àí£¬ÆäËüÌØÊâ×Ö·ûÈç&Ò²Ò»Ñù£¬Èç
insert into t values('i'||chr(39)||'m'); -- chr(39)´ú±í×Ö·û'
»òÕßÓÃÁ½¸öµ¥ÒýºÅ±íʾһ¸ö
or insert into t values('I''m'); -- Á½¸ö''¿ÉÒÔ±íʾһ¸ö'
£¨2£©[Q]Ëæ»ú³éÈ¡Ç°NÌõ¼Ç¼µÄÎÊÌâ
[A]8iÒÔÉÏ°æ± ......
update EMPLOYEE set BADGE=trim(BADGE); // ÕâÑù¿ÉÈ¥³ý×Ö·û´®Á½±ßµÄ¿Õ¸ñ
update EMPLOYEE set BADGE=replace(BADGE,' ',''); // ÕâÑùÄÜÈ¥³ýËùÓеĿոñ
SELECT replace(string,chr(13),'') from DUAL ----»»ÐÐ
SELECT replace(string,chr(10),'') fr ......
1. È¡A±íµÄÊý¾Ý£¬¸üÐÂB±í×Ö¶Î
update m_build b
set b.district_id=(
select d.district_id
from
bjhouse.d_district d
where
b.build_name_jq=d.district_name)
where exists
(select 1
from ......
×òÌì×öÁËÒ»¸öÊý¾Ý¿âµ¼³öµÄʵÑ飬Ö÷ÒªÓÃÀ´²âÊÔexpÃüÁîµÄЧÂÊ
´´½¨Ò»¸öÎļþ CalExpTime.bat£¬ÄÚÈÝÈçÏ£º
echo %time% >time.log
exp user/psw file=exp1.dmp
echo %time% >>time.log
echo %time% >>time.log
exp user/psw file=exp2.dmp direct=y
echo %time% >>time.log
Ë«»÷ÔËÐиÃÅú´¦ÀíÎļþ¡ ......
// Ö´ÐÐÌø¹ý£¬Ìø¹ýµÄ½á¹ûÔÚ
execute dbms_logstdby.skip(stmt => 'DML',schema_name => '%', object_name => '%');
stmtµÄÈ¡Öµ¿ÉÒÔÊÇ£º
http://download-west.oracle.com/docs/cd/B14117_01/appdev.101/b10802/d_lsbydb.htm#997290
// Ìø¹ýµÄÄÚÈݼÇÔØÔÚÏÂÃæ
select * from dba_logstdby_skip
......