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

Oracle 10g Logminer Ñо¿¼°²âÊÔ

LogMinerÌṩÁËÒ»¸ö´¦ÀíÖØ×öÈÕÖ¾Îļþ²¢½«ÆäÄÚÈÝ·­Òë³É´ú±í¶ÔÊý¾Ý¿âµÄÂß¼­²Ù×÷µÄSQLÓï¾äµÄ¹ý³Ì¡£LogMinerÔËÐÐÔÚOracle°æ±¾8.1»òÕ߸ü¸ß°æ±¾ÖС£
 
 
Ò»£¬ÈçºÎʹÓÃLogminer:   
ÏÈÒª°²×°logminerµÄÁ½¸ö°ü£»ÒÔSYSÓû§ÔËÐÐÏÂÃæÁ½¸ö½Å±¾,ÆäÖеÚÒ»¸ö½Å±¾dbmslm.sqlÓÃÀ´´´½¨DBMS_LOGMNR°ü£¬¸Ã°üÓÃÀ´·ÖÎöÈÕÖ¾Îļþ¡£µÚ¶þ¸ö½Å±¾dbmslmd.sqlÓÃÀ´´´½¨DBMS_LOGMNR_D°ü£¬¸Ã°üÓÃÀ´´´½¨Êý¾Ý×ÖµäÎļþ¡£ 
D:\oracle\product\10.2.0\db_1\RDBMS\ADMIN>sqlplus /nolog
SQL*Plus: Release 10.2.0.4.0 - Production onÐÇÆÚÎå4ÔÂ10 17:49:02 2009
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
SQL> conn sys/oracle as sysdba
ÒÑÁ¬½Ó¡£
SQL>
SQL> @dbmslm.sql
³ÌÐò°üÒÑ´´½¨¡£
ÊÚȨ³É¹¦¡£
SQL>
SQL> @dbmslmd.sql
³ÌÐò°üÒÑ´´½¨¡£
 
 
 
¶þ£¬´´½¨Êý¾Ý×ÖµäÎļþ 
    Êý¾Ý×ÖµäÎļþÊÇÒ»¸öÎı¾Îļþ£¬Ê¹ÓðüDBMS_LOGMNR_DÀ´´´½¨£¬Èç¹ûÎÒÃÇÒª·ÖÎöµÄÊý¾Ý¿âÖеıíÓб仯(±ÈÈç±í½á¹¹Óб仯µÈ)£¬Ó°Ïìµ½¿âµÄÊý¾Ý×ÖµäÒ²·¢Éú±ä»¯¡£ÁíÍâÒ»ÖÖÇé¿öÊÇÔÚ·ÖÎöÁíÍâÒ»¸öÊý¾Ý¿âÎļþµÄÖØ×öÈÕ־ʱ£¬Ò²±ØÐëÒªÖØÐÂÉú³ÉÒ»±é±»·ÖÎöÊý¾Ý¿âµÄÊý¾Ý×ÖµäÎļþ¡£ 
Ê×ÏÈÐèÒªÐ޸IJÎÊýUTL_FILE_DIR ,¸Ã²ÎÊýֵΪ·þÎñÆ÷ÖзÅÖÃÊý¾Ý×ÖµäÎļþµÄĿ¼£¬10gÖÐÎÒÃÇͨ¹ý¶¯Ì¬Ð޸IJÎÊýµÄ·½Ê½À´Ð޸ģ¬È»ºóÖØÐÂÆô¶¯Êý¾Ý¿âÉúЧ¡£ÆäÖÐlogs_utl_fileĿ¼ÏÈÆÚ½¨Á¢ºÃ¡£
SQL> alter system set UTL_FILE_DIR='d:\oracle\product\10.2.0\oradata\test\logs_utl_file' scope=spfile;                                                                                                             &


Ïà¹ØÎĵµ£º

30¸öOracleÓï¾äÓÅ»¯¹æÔòÏê½â

1.Ñ¡ÓÃÊʺϵÄOracleÓÅ»¯Æ÷
OracleµÄÓÅ»¯Æ÷¹²ÓÐ3ÖÖ£º
a.RULE(»ùÓÚ¹æÔò)
b.COST(»ùÓڳɱ¾)
c.CHOOSE(Ñ¡ÔñÐÔ)
ÉèÖÃȱʡµÄÓÅ»¯Æ÷£¬¿ÉÒÔͨ¹ý¶Ôinit.oraÎļþÖÐOPTIMIZER_MODE²ÎÊýµÄ
¸÷ÖÖÉùÃ÷£¬ÈçRULE¡¢COST¡¢CHOOSE¡¢ALL_ROWS¡¢FIRST_ROWS¡£Ä㵱ȻҲÔÚSQL¾ä¼¶»òÊǻỰ(session)¼¶¶ÔÆä½øÐи²
¸Ç¡£
ΪÁËʹÓûùÓڳɱ¾µÄÓÅ»¯Æ ......

ORACLEÎÊÌ⼯


¡¡¡¡1. Oracle°²裝Íê³ÉºóµÄ³õʼ¿ÚÁ
¡¡¡¡internal/oracle
¡¡¡¡sys/change_on_install
¡¡¡¡system/manager
¡¡¡¡scott/tiger
¡¡¡¡sysman/oem_temp
¡¡¡¡2. ORACLE9IAS WEB CACHEµÄ³õʼĬÈÏÓû§ºÍÃÜÂ룿
¡¡¡¡administrator/administrator
¡¡¡¡3. oracle 8.0.5Ôõô´´½¨Êý¾Ý¿â£¿
¡¡¡¡ÓÃorainst¡£Èç¹ûÓ ......

Oracleµ÷ÓÃJava´úÂë

 OracleÖпÉÒÔµ÷ÓÃJavaµÄ´úÂ룬һ°ãͨ¹ýÁ½ÖÖ·½Ê½½øÐе÷Óã¬Ò»¸öÊÇÖ±½Ó½«Java´úÂëдÔÚOracleÄÚ²¿£¬ÁíÍâÒ»ÖÖÊǽ«±àÒëºÃµÄclassÎļþÔØÈëµ½OracleÖС£
-A-
1¡¢ÔÚSQLPlusÖд´½¨OracleÖеÄJavaÀàÓë·½·¨£¨·½·¨±ØÐëÊǾ²Ì¬¹«Óз½·¨£©
create or replace and compile java source named hello as
public class Hello {
pu ......

ÔÚweblogic8.14ÀïÃæ²Ù×÷oracle´ó×Ö¶Î

1.Ê×ÏÈ˵Ã÷һϣº
Ô­ÒòÊÇÒòΪÎÒÔÚ×öÕâ¸öÏîĿʱ£¬±»ÏÞÖƵÃÌ«¶à£¬weblogicºÍoracleµÄ°æ±¾²»Äܱ䣬ҪʹÓÃÔ­À´µÄ°æ±¾¡£
Òò´ËÄØ¡£²Ù×÷ÆðÀ´±È½ÏÂé·³¡£¶øÇÒ²»Äܸü¸ÄÔ­±¾¹¤³ÌÀïÃæµÄJar°ü£¨ËüÀïÃæ´æÔÚÁËoracle14.jar°ü£¬µ«±È½Ï¾É£©
weblogic°æ±¾Îª£º8.14
oracle°æ±¾Îª£º9i
2.ÔÚÕâÀïÄØ£¬Ê¹ÓÃhibernate£¬ÒÔÁ÷µÄÐÎʽ¶ÁÈ¡µ½Êý¾ÝÀïÃæ ......

Oracle»¥»»×ܽá

Oracle»¥»»×ܽá
1. ¶àÐл»³ÉÒ»ÐÐ
    col1  col2            col1  col2
    a       1
    a       2     ת»»ºó ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ