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

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)


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 ......

Oracle Êý¾ÝÉú³É Ë÷Òý

1.½¨±í
CREATE TABLE qq(
       qq_num integer
);
2.²åÈëÊý¾Ý
²åÈëÊý¾ÝµÄ·½·¨ÓкܶàÖÖ£¬µ«ÊÇÒª²åÈë3ÒÚÊý¾Ý£¬±ØÐëÒªÓиßЧµÄËã·¨¡£ÔÚ²åÈëÊý¾ÝʱÎÒÓÃÁË×µÄ°ì·¨£¬²ÉÓÃPL/SQLÀûÓÃÁ÷³Ì¿ØÖƵÄLOOPÓï¾ä²åÈ롣ͬʱÎÒÒ²¿´ÁËÍøÉϵIJåÈëЧÂʵÄÓÅ»¯£¬ÔõÑùÀûÓýÏÉÙµÄʱ¼äÉú³É½Ï¶àµÄ²âÊÔÊý¾Ý¡£¸ø ......

oracle Ò»´Îɾ³ý¶àÕűíµÄÊý¾Ý£¨Î´²âÊ԰棩

spool d:\deletetb.sql;
select 'delete ' || table_name || ' where to_char(col,'||'''yyyy'''||')='||'''2007'''||';'
  from user_tables
where table_name in  (select 'HS_' || lpad(rownum, '2', '0')
          from dual
        ......

oracle¹ÜÀí³£ÓÃSQL

1¡¢²é¿´±í¿Õ¼äµÄÃû³Æ¼°´óС  
   
  select   t.tablespace_name,   round(sum(bytes/(1024*1024)),0)   ts_size  
  from   dba_tablespaces   t,   dba_data_files   d  
  ......

OracleÓÃimpµ¼ÈëÓû§±íʱѡÔñ±í¿Õ¼äµÄÎÊÌâ

×Ô¼º¾õµÃ¶ÔOracle»¹ÕÆÎյò»´í£¬²»¹ý×òÌì¸ô±ÚʵÑéÊÒµÄͬѧÎÊÁËÎÒÒ»¸öÎÊÌâÈÃÎÒÓôÃÆÁËÒ»°Ñ¡£ËýÔÚÒ»¸öÊý¾Ý¿âÀï°ÑÒ»¸öÓû§AµÄÔÚ±í¿Õ¼äAAÉϵıí
ÓÃexpµ¼³öµ½exp.dmpÎļþÖУ¬ÔÙ°ÑËüµ¼Èëµ½Áíһ̨»úÆ÷ÉϵÄÊý¾Ý¿âÀÕâʱËýÓõÄÊÇÓû§B£¬Ä¬Èϱí¿Õ¼äÊÇBB£¬µ«ÊÇÓÃimpµ¼ÈëʱÎÒÃÇ·¢ÏÖ±íÊǵ¼Èë
µ½ÁËBÓû§Ï£¬µ«ÊÇ»¹ÊÇ´æÔÚÁËAA±í¿Õ¼äÀïÃæ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ