oracleÊý¾Ý¿âµÄÎÊÌâ
http://localhost:5500/em ÎҵǽÕâ¸öÍøÖ·È´Ã»ÓÐÓóöÏÖµÄÒ³ÃæÎª
Êý¾Ý¿â״̬µ±Ç°²»¿ÉÓ᣿ÉÄÜÊÇÒòΪÊý¾Ý¿âµÄ×´Ì¬Îª×°ÔØ»ò²»×°ÔØ¡£µ¥»÷ 'Æô¶¯' ¿ÉÒÔ»ñµÃµ±Ç°×´Ì¬²¢´ò¿ªÊý¾Ý¿â¡£Èç¹ûÎÞ·¨´ò¿ªÊý¾Ý¿â, µ¥»÷ 'Ö´Ðлָ´' ¿ÉÖ´ÐÐÏàÓ¦µÄ»Ö¸´²Ù×÷¡£
Ïà¹ØÁ´½Ó
Ôõô½â¾ö°¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡
û¿´Ã÷°×£¬¿ÉÄÜÊÇÎÒ¾ÑéÌ«ÉÙ°É£¬¸øÄã¶¥¶¥
Â¥Ö÷£¬ÊDz»ÊÇÊý¾Ý¿â·þÎñûÓпªÆô°¡£¿
ÔÚ·þÎñÀï´ò¿ªÒ»ÏÂ
Æô¶¯Á˰¡£¡£¡£¡ÎҵķþÎñÆ÷¿ªÆôÁË£¡
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN
......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
declare
TYPE test_rec IS record(
code varchar(10),
name varchar(30)
);
v_book test_rec;
......
oracle 11g °²×° 01092 ´íÎó,
ÈÕÖ¾ÐÅÏ¢£º
[oracle@linux trace]$ vi alert_orcl.log
MMON started with pid=14, OS id=9089
RESETLOGS after incomplete recovery UNTIL CHANGE 522752
Errors in file / ......
²é¿´ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁ
MySQLʹÓõÄÊÇselect @@tx_isolation;
ÔÚOracleÖв鿴ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁîÊÇÄĸö£¿
SQL code:
SELECT /*+ rule */ s.username,decode(l.type,'TM','TABLE LOCK','TX','ROW LOCK', ......