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

Oracle DBA Á½ÈÕËٳɿγÌ

http://www.oracle.com/technology/global/cn/obe/2day_dba/index.html
¿Î³ÌÁбí
1
¹ÜÀíÊý¾Ý¿âµÄÒªËØÊÇʲô£¨Ã»Óб¾Õ¶ÔÓ¦µÄ¸½¼Ó×ÊÁÏ£©
2
°²×° Oracle ºÍ¹¹½¨Êý¾Ý¿â
3
Oracle Enterprise Manager Êý¾Ý¿â¿ØÖÆÈëÃÅ
4
ÅäÖÃÍøÂç»·¾³
5
¹ÜÀí Oracle Àý³Ì
6
¹ÜÀíÊý¾Ý¿â´æ´¢½á¹¹
7
¹ÜÀíÓû§ºÍ°²È«ÐÔ
8
¹ÜÀíģʽ¶ÔÏó
9
Ö´Ðб¸·ÝºÍ»Ö¸´
10
¼à¿ØºÍµ÷ÕûÊý¾Ý¿â


Ïà¹ØÎĵµ£º

oracle ¼ì²é±»ËøµÄ±í¼°½âËø

´¦Àí·½·¨Ò» £º
¼ì²éÄǸö±í±»Ëø
select sess.sid,sess.serial#, lo.oracle_username,lo.os_user_name,ao.object_name,lo.locked_mode
from v$locked_object lo,dba_objects ao,v$session sess
where ao.object_id = lo.object_id
and lo.session_id = sess.sid;
½âËø
alter system kill session '273,45';
´¦Àí·½·¨¶ ......

Oracle´¥·¢Æ÷µÄʹÓÃ

´¥·¢Æ÷ÊÇÖ¸´æ·ÅÔÚÊý¾Ý¿âÖУ¬²¢±»Òþ²ØÖ´ÐеĴ洢¹ý³Ì¡£ÔÚOracle8i֮ǰ£¬Ö»ÔÊÐí»ùÓÚ±í»òÊÓͼµÄDML²Ù×÷(insert,update,delete)½¨Á¢´¥·¢Æ÷£¬ÔÚoracle8iÖ®ºó£¬²»½öÖ§³ÖDML²Ù×÷£¬Ò²ÔÊÐí»ùÓÚϵͳʼþ(Æô¶¯Êý¾Ý¿â£¬¹Ø±ÕÊý¾Ý¿â£¬µÇ¼)ºÍDDL²Ù×÷½¨Á¢´¥·¢Æ÷¡£
Ò»¡¢´¥·¢Æ÷¼ò½é
   ´¥·¢Æ÷ÊÇÖ¸Òþº¬Ö´ÐеĴ洢¹ý³Ì£¬Ëü¿ÉÒÔʹ ......

´«ÖDz¥¿ÍjavaÅàѵORACLE×ܽá(3)


 
ORACLEµÄѧϰÒѾ­¸æÒ»¶Î茖£¬½ñÌìÒѾ­¿ªÊ¼HIBERNATEµÄѧϰ£¬×ÜÌå¸Ð¾õͦÁ¼ºÃµÄ£¬ËäÈ»ºÜ¶àµÄ֪ʶ²»ÄܼÇס£¬µ«ÊÇÔÚʹÓõÄʱºòÄܹ»Ñ¸ËÙµÄÕÒ¶Ô·½·¨À´½â¾öÏàÓ¦µÄÎÊÌ⣬ֻҪÇÚ¼ÓÁ·Ï°£¬¾Í¿ÉÒÔ¼Çס¡£Ö»²»¹ý£¬Ê±¼äÓÐ珢£¬HIBERNATEµÄ¿Î³ÌÒ²Ö»ÓÐÈýÌìµÄʱ¼ä£¬ËùÒÔÔÚÕâÆÚ¼äÎÒµÄÈÎÎñÊǾ¡Á¿ÎüÒý£¬ÔÚ»¨·Å¼ÙµÄʱºòÀ´¸´Ï° ......

oracle¼òµ¥stream Ò»¸öÓû§µ¥Ïò¸´ÖÆÅäÖÃ

ÒÔÏÂÎÒ×östreammͬ²½Á½Ì¨»úÆ÷¼äµÄijһ¸öÓû§µÄ²Ù×÷²½Öè¡£ºÜ¼òµ¥,¿´µ½stream
»¹
ÓкܶàÒª¿´µÄ¡£
1.»·¾³½éÉÜ
  Ö÷Êý¾Ý¿âSID : obpm
  ²Ù×÷ϵͳ :    win 2003
  IPµØÖ·   :  192.168.0.1
  Global_name :
  oracle
version: 10.2.0.1
  ´ÓÊý¾Ý¿âSID ......

oracle ¹ÙÍøÎÞ·¨·ÃÎʵÄÎÊÌâ

×î½üÓöµ½ÔÚwindows 2008ÏÂIEÆäËüµÄÍøÒ³¶¼¿ÉÒÔ·ÃÎÊ,ΨÓÐoracle.com²»ÄÜ·ÃÎÊ,ÕæÓôÃÆÁË,ºóÀ´ÕÒÒ»´úÀí,·ÃÎÊËÙ¶È»¹¿ÉÒÔ,ÅäÖÃÈçÏÂ:
Õâ¸ö´úÀíµÚÒ»´Î·ÃÎʵϰ£¬ÐèÒªÌøµ½ËûµÄÖ÷Ò³£¬¹ý¸öÊ®¼¸ÃëÖоͿÉÒÔÌø×ªµ½OracleµÄ¹Ù·½ÍøÕ¾ÁË¡£
—————————————&md ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ