oracle×¢ÊÍ£ºcomment onµÄÖØÒªÒâÒå
	
    
    
	ÎÞÒÉ×¢ÊÍÏÖÔÚ¶¼±»´ó¼Ò½ÓÊܺÍÈϿɣ¬ÔÚ´ó¼Ò±à³ÌÓõÄIDEÖж¼Ìṩ»òÓеÚÈý·½²å¼þÀ´Ö§³ÖÌáȡעÊÍÄÚÈÝʵÏÖ   
¿ìËÙÁ˽â½á¹¹µÄ¹¦ÄÜ¡£µ«ÔÚÊý¾Ý¿âµÄ½Å±¾±àд·½ÃæÎÒÒ²ÊǾÀúÁ˰ٰãÕÛÄ¥ºó×ܽáÁËһЩ¶«Î÷·¢À´Óë´ó¼ÒÇд衣    
ÏÂÃæÀ´¿´Ò»¸öOracle½¨±íµÄ·½Ê½¡£    
create table ctable_name    
(    
       field1 varchar2(20), --×¢Ê͵ÄÄÚÈÝ1    
       field2 number,       --×¢Ê͵ÄÄÚÈÝ2    
       field3 char(2),      --×¢Ê͵ÄÄÚÈÝ3    
       field4 date          /*×¢Ê͵ÄÄÚÈÝ4*/     
)    
֮ǰһֱ¶¼ÊÇÕâÑùÀ´½¨±í£¬¾õµÃ¿ìËÙÒ²ºÃÀí½â£¬ÆäʵÊý¾Ý¿â½á¹¹²»¸´ÔÓµÄÇé¿öÏÂÎÒҲϲ»¶ÕâÖÖ·½Ê½£¬µ«µ±Êý¾Ý¿â½á¹¹ºÜ¸´ÔÓµÄʱºòά»¤ÆðÀ´¾ÍºÜÍ·ÌÛ£¬Ò»¸öSQL¼¸°ÙK£¬¿´µÄÄãÑÛ¶¼»¨ÁË£¬¶øÇÒÓÐN¸öÕâÑùµÄSQLÎļþ£¬ÄÇôÔÚ¶Ô²»Á˽âµÄ¸´ÔÓµÄÊý¾Ý¿â½á¹¹ÊµÏÖ¿ìËÙ±à³Ì·½Ã棬ΪÁËÁ˽â½á¹¹²éÕÒ×¢Ê͵Ť×÷Á¿Ò²ºÜ´ó¡£    
ÓÈÆä¹«Ë¾ÏîÄ¿ÒѾ×öÁË5ÄêÁË£¬ºÃ¶àSQL½Å±¾¶¼Ã»ÁË£¬ÄÇôÊý¾Ý½á¹¹Ö»ÄÜÎÊÀϵÄͬÊ£¬µ«¶ÔÓÚÈËÔ±¸üÌæÆµ·±µÄ¹«Ë¾µ±ÀϳÌͬʶ¼»»Á˼¸Åú£¬¶¼²»ÔÚÁË£¬Ã»ÈË¿ÉÎÊ£¬ÄÇôά»¤ÈËÔ±»òºóÐø¿ª·¢ÈËÔ±¾Íµô½øÁËÎÞ¾¡µÄÍ´¿àÖУ¬ºÃ¶àÎÊÌâ¶¼ÊdzöÔÚÕâÉÏÃæ¡£ºóÆÚͶÈë³É±¾Ò²ÊǺܾ޴óµÄ¡£Èç¹ûÊý¾Ý¿â½á¹¹ÃüÃûʲôµÄ±È½Ï¹æ·¶»¹ºÃ£¬¿ÉÒÔÆ¾×ÖÃæÒâ˼ȷ¶¨´ó¸ÅÓÃ;£¬·´Ö®ÕæÊµ¿à²»¿°ÑÔ¡£¶øÇÒ֪ʶµÄ´«µÝµ±ÖÐÊÇÓÐÈËΪÒòËØµ¼ÖµÄȱʧµÄ¡£¾ÙÀýÀ´Ëµ¾ÍÊÇÒ»°ãÔ±¹¤À뿪¹«Ë¾Ö®Ç°»áÓÃÒ»¸öÔµÄʱ¼äÀ´½»½Ó£¬µ«´ó²¿·Ö¶¼ÊÇÓà    
Ò»ÖÜ×óÓÒµÄʱ¼äÀ´½»½Ó¹¤×÷£¬ÄÇô½»½ÓµÄ×ÔÈ»»áÓÐÒâʶµÄºöÂÔһЩСµÄ»òÑÚ¸ÇһЩÓÐÎÊÌâµÄµØ·½Ö»ËµÖ÷ÒªºÃʹµÄµØ·½£¬Èç¹û½»½ÓµÄÊÇÒ»¸ö¶Ô½á¹¹Á˽âµÄͬÊ»¹ºÃ£¬¸ù¾ÝÏàÓ¦µÄ¾Ñ飬³Ð½Ó²»ÊÇÎÊÌ⣬µ«Èç¹û½»½Ó¸øÐµÄͬÊ£¬ÐÂͬÊÂ½ÓÆðÀ´ºÜ·Ñ¾¢£¬¶øÒª×ßµÄͬÊÂÒª½øµÄ¹«Ë¾»¹´ßËûËٶȰìÀëÖ°£¬ÄÇôȱʧµÄ²¿·Ö¾ÍÒªÐÂͬÊÂÀ´ÃÖ²¹£¬µ±È»Èç¹ûËûÊǸö¸ºÔðµÄÈ˵±Ëû·¢ÏÖËäÈ»ÏîÄ¿¿ÉÒÔ½øÐлò˵³ÌÐò¿ÉÒÔÅÜÆðÀ´µ«ÓÐЩ¶«Î÷£¬Ò»°ãÊÇϸ½ÚµÄ¶«Î÷Ëû»¹²»Á˽âÐèÒª´òµç»°¸øÔÀ´µÄͬÊÂÀ´ÅªÇå³þ£¬ÄÇôҲ²»»áÓÐʲôÎÊÌ⣬µ«ÎÒ˵µÄÊÇÈç¹û£¬Ò»°ãµÄÈËÔÚ¿´µ½ÏîÄ¿Äܹ»½øÐУ¨³ÌÐòÄÜÅÜÆðÀ´£©ÊDz»»áȥŪÄÇЩ¶«Î÷µÄ£¬ÕâÑùÑ»·ÏÂÈ¥£¬×îºóά»¤Õâ¸ö³ÌÐò»òºóÐø¿ª·¢µÄµ¹Ã¹µ°¾ÍÓеĿà³ÔÁË£¬ÎÒÌå»
    
     
	
	
    
    
	Ïà¹ØÎĵµ£º
        
    
    
Using Oracle Trace Analyzer (trcanlzr.sql)
Dave Moore:  Author of Oracle Utilities
Oracle has provided another utility initially designed for performance tuning Oracle Applications.  Trace Analyzer is provided in the form of a PL/SQL package (TRCA$ ).  The Trace Analyzer utility i ......
	
    
        
    
    À´Ô´ÓÚhttp://hi.baidu.com/edeed/blog/item/33576327d1b73d00918f9dd4.html
±¾ÊÓͼ×ÔÆô¶¯¼´±£³Ö²¢¼Ç¼¸÷»Ø¹ö¶Îͳ¼ÆÏî¡£ÔÚѧϰ±¾ÊÓͼ֮ǰ£¬ÎÒÃÇÏÈÀ´Á˽âһϻعö¶Î(rollback segment)µÄÏà¹Ø¸ÅÄ
»Ø¹ö¶Î¸ÅÊö
»Ø¹ö¶ÎÓÃÓÚ´æ·ÅÊý¾ÝÐÞ¸Ä֮ǰµÄÖµ£¨°üÀ¨Êý¾ÝÐÞ¸Ä֮ǰµÄλÖúÍÖµ£©¡£»Ø¹ö¶ÎµÄÍ·²¿°üº¬ÕýÔÚʹÓõĸûعö¶ÎÊÂÎñµÄÐ ......
	
    
        
    
    
1.LOWER(str) Ç¿ÖÆÐ¡Ð´
2.UPPER(str) Ç¿ÖÆ´óд
3.INITCAP(str) ÿ¸öµ¥´ÊÊ××Öĸ´óд
ʾÀý£º
SQL> select initcap('my_boy') from dual; --·µ»Ø"My_Boy"
×¢Ò⣺µ¥´ÊÖ®¼äÓÃÏ»®Ïߣ¨"_"£©·Ö¸î
4.CONCAT(str1,str2£©Á¬½Óº¯Êý,Á¬½Óstr1ºÍstr2×Ö·û´®
5.SUBSTR(string,a[,b])·µ»ØstringµÄÒ»²¿·Ö£¬aºÍbÒÔ×Ö·ûΪµ¥Î»¡£´Ó× ......
	
    
        
    
    DBA£ºLinux
ÔÚ Linux x86 Éϰ²×° Oracle RAC 10g 
×÷ÕߣºJohn Smiley 
Á˽âÔÚ Red Hat Enterprise Linux »ò Novell SUSE Enterprise Linux ÉÏ´ÓÍ·°²×° Oracle RAC 10g µÄ»ù´¡ÖªÊ¶£¨½öÓÃÓÚÆÀ¹À£© 
Ŀ¼
¸ÅÊö
±³¾°
µÚ 1 ²¿·Ö£º °²×° Linux
µÚ 2 ²¿·Ö£º Ϊ Oracle ÅäÖà Linux
µÚ 3 ²¿·Ö£º ×¼±¸¹²Ïí´ÅÅÌ
µÚ 4 ²¿·Ö£º  ......
	
    
        
    
    ·½·¨Ò»£º
SQL>create table aa(a number);
´´½¨³É¹¦¡£
SQL> select * from aa;
A
--------
2
SQL> 
SQL> insert all
2 into aa values(1)
3 into aa values(2)
4 select * from dual;
ÒÑ´´½¨2ÐС£
SQL> commit;
Ìá½»Íê³É¡£
SQL> select * from aa;
A
---------- 
2
1
2
·½·¨¶þ£º
S ......