Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

oracleͨ¹ýÊý¾Ý×Öµä²éѯ¿´Ö´Ðмƻ®

SELECT a.ADDRESS,
       sql_text,
       executions,
       rows_processed,
       cpu_time,
       a.DISK_READS,
       a.BUFFER_GETS,
       a.ELAPSED_TIME,
       a.*
  from V$SQLAREA a
 WHERE sql_text LIKE '%mazhanling%'
   AND sql_text NOT LIKE '%SQLAREA%';
select lpad(' ', 2 * (level - 1)) || operation "Operation",
       options "Options",
       decode(to_char(id),
              '0',
              'Cost=' || nvl(to_char(position), 'n/a'),
              object_name) "Object Name",
       substr(optimizer, 1, 6) "Optimizer"
  from v$sql_plan a
 start with address = '0700001054479520'
        and id = 0
connect by prior id = a.parent_id
       and prior a.address = a.address
       and prior a.hash_value = a.hash_value;


Ïà¹ØÎĵµ£º

OracleÖеÄÈÕÆÚºÍ×Ö·û´®»¥Ïàת»»

 OracleÖеÄÈÕÆÚºÍ×Ö·û´®»¥Ïàת»»
TO_DATE¸ñʽ(ÒÔʱ¼ä:2007-11-02   13:45:25ΪÀý)
  
        Year:     
        yy two digits Á½Î»Äê         ......

C#Á¬½ÓoracleµÄdllÎļþµÄ±àд¹ý³Ì

 ³õѧc#¼ÓOracle±à³Ì£¬¿´ÁËÐí¶àÍøÉϽ̳̣¬¶¼½éÉܵÄÊÇadoÁ¬½Ó·½Ê½£¬¶øÇÒ²ÉÓõͼÊÇÔÚºǫ́ÊäÈëÁ¬½Ó×Ö·û´®µÄ·½Ê½¡£ÓÚÊÇÃÈÉúÁËдһ¸ödllÎļþÀ´´úÌæÕâ¸öÁ¬½Ó×Ö·û´®£¬ÒÔºóÿ´ÎÁ¬½ÓÊý¾Ý¿âÊÂÖ»Òªµ÷ÓÃÕâ¸ödllÎļþ¾ÍÐеÄÏë·¨¡£ÏÐÑÔÉÙÐ𣬽«´úÂëд³ö£¬ ......

perl½«oracleÊý¾Ý¿âµÄÊý¾Ýµ¼³ö³ÉtxtµÄ¼òµ¥·½Ê½

 µ±ÎÒÃÇÃæ¶Ô Êý°ÙÍòÊýǧÍòÐÐÁеÄÊý¾Ý¿â±íµÄʱºò£¬¶øÄãÓÖÏ£ÍûÄܽ«Êý¾Ý¾¡¿ìµÄµ¼³ö³Étxt¸øÄãµÄÀϰ壬ÓÐÈí¼þ»òÕ߯äËû¶«Î÷µ¼³öÀ´¾ÍÏԵñȽÏÓôÃÆÁË£¬ÒòΪÀϰåÒª³ÔÎç·¹ÁË£¬Ëû¿É²»Ï£ÍûÔÚϰàµÄʱºò»¹Ìýµ½ÄãÔÚ˵£¬Êý¾ÝÕýÔÚµ¼³öÖС£
   ÓÚÊÇÎÒÃÇÀûÓÃÁË£¬ËÙ¶ÈתÈëÕýÌâÁ˰¡¡£
ÐèÒªµÄÄ£¿é£º
DBI£»
#!/usr/bin/pe ......

½øÈë oracle enterprise managerment ³öÏÖÎÊÌâ

    ÎÊÌâ1£º ½øÈëʱÐèÒªÖ÷»úÉí·ÝÖ¤Ã÷£º ½â¾ö·½°¸£º¹ÜÀí¹¤¾ß——±¾µØ°²È«²ßÂÔ——Óû§È¨ÀûÖ¸ÅÉ——×÷ΪÅú´¦Àí×÷ÒµµÈ¼£¨×îºóÒ»Ï——Ìí¼Ó±¾»úµÄÕ˺ÅÓëÃÜÂë ......

ѧϰOracleÖÐBlobºÍClobÒ»µãµãÐĵÃ

BlobÊÇÖ¸¶þ½øÖÆ´ó¶ÔÏóÒ²¾ÍÊÇÓ¢ÎÄBinary Large ObjectµÄËùд£¬¶øClobÊÇÖ¸´ó×Ö·û¶ÔÏóÒ²¾ÍÊÇÓ¢ÎÄCharacter Large ObjectµÄËùд¡£Óɴ˿ɼûÕâÁ¾¸öÀàÐͶ¼ÊÇÓÃÀ´´æ´¢´óÁ¿Êý¾Ý¶øÉè¼ÆµÄ£¬ÆäÖÐBLOBÊÇÓÃÀ´´æ´¢´óÁ¿¶þ½øÖÆÊý¾ÝµÄ£»CLOBÓÃÀ´´æ´¢´óÁ¿Îı¾Êý¾Ý¡£
ÄÇôÓÐÈ˿϶¨ÒªÎʼÈÈ»ÒѾ­ÓÐVARCHARºÍVARBINARYÁ½ÖÐÀàÐÍ£¬ÎªÊ²Ã´»¹ÒªÔÙÊ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ