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

Oracle·ÖÎö±íºÍË÷Òý(analyze)

analyze table tablename compute statistics;
analyze index indexname compute statistics;
¶ÔÓÚʹÓÃCBOºÜÓкô¦£¬¿ÉÒÔʹÓøü¿É¿¿µÄtableÐÅÏ¢£¬´Ó¶øÖ´Ðмƻ®Ò²¿ÉÒÔ¸ü׼ȷһЩ£¬ÔÚ10g»á×Ô¶¯analyze£¬Ö®Ç°µÄ°æ±¾ÐèÒªÊÖ¶¯¶¨ÆÚ
Éú³Éͳ¼ÆÐÅÏ¢,,Ñ¡ÔñºÏÀíµÄÖ´Ðмƻ®..
OracleµÄonline documentÕâÑùÃèÊöanalyzeµÄ×÷Óãº
Use the ANALYZE statement to collect non-optimizer statistics, for example, to:
1¡¢Collect or delete statistics about an index or index partition, table or table partition, index-organized table, cluster, or scalar object attribute.
2¡¢Validate the structure of an index or index partition, table or table partition, index-organized table, cluster, or object reference (REF).
3¡¢Identify migrated and chained rows of a table or cluster.
¶ÔÓÚÊÕ¼¯Í³¼ÆÐÅÏ¢Õâ¿é£¬ÎÒÒ»°ãʹÓÃdbms_statsÕâ¸öpackage£¬ÊÕ¼¯Í³¼ÆÐÅÏ¢µÄ×öÓÃʹCBO·½Ê½µÄÓÅ»¯Ñ¡ÔñÖ´Ðмƻ®¸ü׼ȷ¡£
ͳ¼ÆÐÅÏ¢×îºÃ¶¨ÆÚÊÕ¼¯£¬ÒÔÒµÎñµÄ²»Í¬È·¶¨²»Í¬µÄÊÕ¼¯ÖÜÆÚ¡£


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

ÌáÈ¡Oracleµ±Ç°Óû§Ãû£¬»úÆ÷Ãû£¬IPµÄ·½·¨

select sysdate  µ±Ç°Ê±¼ä,
       sys.login_user  Êý¾Ý¿âÓû§,
       machine   µÇ¼»úÆ÷Ãû,
       SYS_CONTEXT('USERENV', 'IP_ADDRESS')   µÇ¼IP,
     &n ......

Oracle Êý¾ÝÀàÐÍ


Êý¾ÝÀàÐÍ
²ÎÊý
ÃèÊö
char(n)
n=1 to 2000×Ö½Ú
¶¨³¤×Ö·û´®£¬n×Ö½Ú³¤£¬Èç¹û²»Ö¸¶¨³¤¶È£¬È±Ê¡Îª1¸ö×Ö½Ú³¤£¨Ò»¸öºº×ÖΪ2×Ö½Ú£©
varchar2(n)
n=1 to 4000×Ö½Ú
¿É±ä³¤µÄ×Ö·û´®£¬¾ßÌ嶨ÒåʱָÃ÷×î´ó³¤¶Èn£¬
ÕâÖÖÊý¾ÝÀàÐÍ¿ÉÒÔ·ÅÊý×Ö¡¢×ÖĸÒÔ¼°ASCIIÂë×Ö·û¼¯(»òÕßEBCDICµÈÊý¾Ý¿âϵͳ½ÓÊܵÄ×Ö·û¼¯±ê×¼)ÖеÄËùÓзûºÅ¡£
Èç¹ ......

ÅäÖöà¸öSDE·þÎñ(oracle)

ÅäÖöà¸öSDE·þÎñ(oracle)  ÏîĿҪ׼±¸Á½·ÝÏàͬ½á¹¹µÄÊý¾Ý¸ø²»Í¬µÄÓû§£¬ÓÉÓÚÊý¾ÝÁ¿ºÜ´ó£¬²»¶ÏµÄ±¸·Ý»¹Ô­Ð§ÂÊÊ®·ÖµÍÏ£¬Òò´Ë¿¼ÂÇн¨Ò»¸öÊý¾Ý¿â£¬½¨Á¢Á½¸öSDE·þÎñ¡£
1.н¨Êý¾Ý¿âDXGX_GX(Ô­Êý¾Ý¿â£ºDXGX)
2.ÔËÐÐSDE POST д´½¨Ò»¸ö·þÎñ£¨ÔÚ´´½¨Ö®Ç°ÐèÒªÏȹرÕÒÑÔÚÔËÐÐÖеÄSDE·þÎñ£©
3.ÔÚArcCatalogÀィÁ¢ÐµÄSDEÁ¬ ......

²é¿´Oracle×Ö·û¼¯¼°ÔõÑùÐÞ¸Ä×Ö·û¼¯£¨zt£©


Ò»¡¢Ê²Ã´ÊÇoracle×Ö·û¼¯ ¡¡¡¡
Oracle×Ö·û¼¯ÊÇÒ»¸ö×Ö½ÚÊý¾ÝµÄ½âÊ͵ķûºÅ¼¯ºÏ,ÓдóС֮·Ö,ÓÐÏ໥µÄ°üÈݹØÏµ¡£ORACLE
Ö§³Ö¹ú¼ÒÓïÑÔµÄÌåϵ½á¹¹ÔÊÐíÄãʹÓñ¾µØ»¯ÓïÑÔÀ´´æ´¢£¬´¦Àí£¬¼ìË÷Êý¾Ý¡£ËüʹÊý¾Ý¿â¹¤¾ß£¬´íÎóÏûÏ¢£¬ÅÅÐò´ÎÐò£¬ÈÕÆÚ£¬Ê±¼ä£¬»õ±Ò£¬Êý×Ö£¬ºÍÈÕÀú×Ô¶¯ÊÊÓ¦±¾µØ
»¯ÓïÑÔºÍÆ½Ì¨¡£ ¡¡¡¡
Ó°ÏìoracleÊý¾Ý¿â×Ö·û¼¯ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ