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

oracleÊý¾Ý¿âµÄÎÊÌâ

http://localhost:5500/em ÎҵǽÕâ¸öÍøÖ·È´Ã»ÓÐÓóöÏÖµÄÒ³ÃæÎª  
Êý¾Ý¿â״̬µ±Ç°²»¿ÉÓ᣿ÉÄÜÊÇÒòΪÊý¾Ý¿âµÄ×´Ì¬Îª×°ÔØ»ò²»×°ÔØ¡£µ¥»÷ 'Æô¶¯' ¿ÉÒÔ»ñµÃµ±Ç°×´Ì¬²¢´ò¿ªÊý¾Ý¿â¡£Èç¹ûÎÞ·¨´ò¿ªÊý¾Ý¿â, µ¥»÷ 'Ö´Ðлָ´' ¿ÉÖ´ÐÐÏàÓ¦µÄ»Ö¸´²Ù×÷¡£


Ïà¹ØÁ´½Ó

Ôõô½â¾ö°¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡
û¿´Ã÷°×£¬¿ÉÄÜÊÇÎÒ¾­ÑéÌ«ÉÙ°É£¬¸øÄã¶¥¶¥

Â¥Ö÷£¬ÊDz»ÊÇÊý¾Ý¿â·þÎñûÓпªÆô°¡£¿

ÔÚ·þÎñÀï´ò¿ªÒ»ÏÂ

Æô¶¯Á˰¡£¡£¡£¡ÎҵķþÎñÆ÷¿ªÆôÁË£¡


Ïà¹ØÎÊ´ð£º

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

[Ô­´´] ORACLE Á¬½Ó×Ö´® - Oracle / ·Ç¼¼ÊõÇø

¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰 
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN ......

Ò»¸öpl/sqlÎÊÌâ - Oracle / ¿ª·¢

ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
  declare
  TYPE test_rec IS record(
  code varchar(10),
  name varchar(30)
  );
  v_book test_rec;
    ......

oracle °²×° 01092 ´íÎó - Oracle / »ù´¡ºÍ¹ÜÀí

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

Çë½ÌOracleÊÂÎñ¸ôÀë¼¶±ðÎÊÌâ - Oracle / ·Ç¼¼ÊõÇø

²é¿´ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁ
MySQLʹÓõÄÊÇselect @@tx_isolation;
ÔÚOracleÖв鿴ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁîÊÇÄĸö£¿

SQL code:

SELECT /*+ rule */ s.username,decode(l.type,'TM','TABLE LOCK','TX','ROW LOCK', ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ