oracle 10gÈÕÖ¾²é¿´·½·¨ - Oracle / ¿ª·¢
ÏêϸµÄ²½Öè¡£¡£ ÍùÉÏÕҵͼÊDZðÈ˵½´¦¿½±´µÄ¡£¡£
ÎÒµÄoracle°æ±¾Îª10g
Êý¾ÝÎļþ£¬¿ØÖÆÎļþ£¬ÈÕÖ¾ÎļþµÄµØÖ·Îª£ºE:\oracle\product\10.2.0\oradata\orcl
²ÎÊýÎļþÔÚ E:\oracle\product\10.2.0\admin\orcl\pfile
ллÁË¡£¡£
¾±¾ÈËÈ·ÈϺó½áÌù¸ø·Ö¡£¡£
http://blog.csdn.net/tianlesoftware/archive/2010/05/19/5604497.aspx
ÎÒÏàÐÅËûµÄBOLG....Äã¿´¿´ÄÇ..ÓÐÎÊÌâ¿ÉÒÔÎÊËû...
1¡¢
Èç¹ûÂ¥Ö÷ÏëÒª²é¿´µÄÊDZ¨¾¯ÈÕÖ¾£¨alert log£©µÄ»° ¿ÉÒÔÔÚÈçÏ·¾¶²é¿´ Ö±½ÓÓÃÎı¾±à¼Æ÷¾Í¿ÉÒÔ´ò¿ª
E:\oracle\product\10.2.0\admin\orcl\bdump
ÀïÃæÓ¦¸ÃÓиöalert_orcl.log
2¡¢
Èç¹ûÂ¥Ö÷Ïë²é¿´µÄÊÇÁª»úÖØ×öÈÕÖ¾£¨online redo log£©µÄ»° ¿ÉÒÔʹÓÃlogminerÈ¥²é¿´ ʹÓ÷½·¨ÍøÉϺܶà Ëæ±ãËÑһϾÍÓÐ
ÕâλÈÊÐֵIJ©¿Í¹ûÈ»²»´í!
û´íû´í ÎÒ¾ÍÒª¿´redolog
¾ÍÏëÓÃlogminer Õâ¸ö¡£
ѧϰÁË
1¡¢
Èç¹ûÂ¥Ö÷ÏëÒª²é¿´µÄÊDZ¨¾¯ÈÕÖ¾£¨alert log£©µÄ»° ¿ÉÒÔÔÚÈçÏ·¾¶²é¿´ Ö±½ÓÓÃÎı¾±à¼Æ÷¾Í¿ÉÒÔ´ò¿ª
E:\oracle\product\10.2.0\admin\orcl\bdump
ÀïÃæÓ¦¸ÃÓиöalert_orcl.log
2¡¢
Èç¹ûÂ¥Ö÷Ïë²é¿´µÄÊÇÁª»úÖØ×öÈÕÖ¾£¨online redo log£©µÄ»° ¿ÉÒÔʹÓÃlogminerÈ¥²é¿´ ʹÓ÷½·¨ÍøÉϺܶà Ëæ±ãËÑһϾÍÓÐ
LogMinerµÄʹÓà : ÎÒǰ²»¾Ã²Åʱ¼äʵÑéºó×ܽáµÄ,Äã¿´¿´°É:
http://blog.sina.com.cn/s/blog_3fb41b900100h497.html
Ïà¹ØÎÊ´ð£º
CREATE OR REPLACE PROCEDURE usp_refreshTopN
IS
BEGIN
--Îĵµ
INSERT INTO topnresource(resourceId,title,type,cover,brief,properUser,tag,clickAmount,createDate,topNCreateDate,o ......
ÏÖÔÚ ÎÒÓÐ Êý¾Ý¿â oracle_A £¬ÀïÃæÓÐÕűí Ϊ table_A, È»ºóÎÒÒª¶¨Ê±µÄ °Ñ ÁíÒ»¸öÊý¾Ý¿â oracle_B,ÀïÃæµÄÒ»Õűí table_BµÄÊý¾Ý£¬ÐÂÔö·ÅÈëtable_AÀȻºóÔÙÇå¿Õtable_B£¬ÇëÎÊÓ¦¸ÃÔõô×ö£¿
ÓÃд¸ö´æ´¢¹ý³Ì£¬È»ºóÓ ......
ÎÒÔÚ³ÌÐòÖн«oracleÊý¾Ý¿âµÄ¶«Î÷select³öÀ´ ÔÙ²åÈëµ½MDBÖÐ £¬È»ºóÔÙMDBÖв鿴µÄʱºò·¢ÏÖÓкܶà×Ö¶ÎÖµ¶¼Ëð»µÁËÎÞ·¨ÏÔʾ£¬ÔÚµ¼³ö¹ý³ÌÖÐûÓгöÏÖ´íÎ󣬲»ÖªµÀÊÇʲôÔÒòÔì³ÉµÄ°¡£¿
ÀàÐÍ¿ÉÊÇÒ»Öµģ¿
ÒýÓÃ
ÀàÐÍ¿É ......