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

¡¾×ª¡¿Oracle¼à¿Ø¹¤¾ß¸ÅÀÀ


Oracle¼à¿Ø¹¤¾ß¸ÅÀÀ
Kaya ·¢±íÓÚ os2ora.com
дÁËLinuxÉϵļà¿ØÓë·ÖÎö¹¤¾ß
Ö®ºó£¬Ð´Ð´OracleÉÏÏàÓ¦µÄ¼à¿ØÓë·ÖÎö¹¤¾ß»¹ÊÇͦÓÐÒâ˼µÄ£¬Ò»·½Ãæ¿ÉÒÔ¸ü¼ÓÍêÕû£¬Ò»·½Ãæ¿ÉÒÔ½øÐкáÏò¶Ô±È¡£
LinuxÉϵÄÐÔÄÜÊý¾ÝÒ»°ã¶¼À´×ÔÓÚ/procÎļþϵͳ£¬¶øOracleÔòÊÇÀ´×ÔÓÚV$ÊÓͼ¡£Òò´Ë£¬ËùÓеÄOracle¼à¿Ø¹¤¾ßµÄʵÏÖ¶¼Íò±ä²»Àë
V$
ÊÓͼ¡£¶øÕâЩ¸öÊÓͼÀïÃ棬×îÖØÒªµÄÓ¦ÍÆv$sysstat¡£ÀïÃæ¼Ç¼×ÅInstanceÒ»¼¶µÄ¸÷¸öͳ¼ÆÊý¾ÝµÄµ±Ç°Öµ£¬ÀýÈçCPUÀûÓÃÇé¿ö£¬Âß¼­
¶Á£¬Redo
SizeµÈµÈ¡£10gºóÓÐÁËÁíÒ»¸öÖØÒªµÄÊÓͼ£¬½Ðv$active_session_history,ͨ¹ýËü¿ÉÒÔÈÝÒ׵صÃÖªµ±Ç°InstanceµÄ»î¶¯×´
̬£¬Ö÷ÒªÊǸ÷¸öʱ¿Ìϵͳ¶¼ÔڵȴýÄÄЩʼþ£¬Í¨¹ý¶ÔÕâЩµÈ´ýʼþºÍÏàÓ¦µÈ´ý´ÎÊýµÄͳ¼Æ£¬¾Í¿ÉÒÔÇåÎúµØÁ˽âϵͳµÄÀúÊ·¹¤×÷¸ºÔØÌØÕ÷ºÍѹÁ¦Çé¿ö¡£Èç¹ûÏë»ñÈ¡µ±Ç°
ÕýÔÚÖ´ÐеÄSQL£¬Ôò¿É²éѯv$sqlÊÓͼ¡£Èç¹ûÏë»ñÈ¡µ±Ç°SQLµÄÖ´Ðмƻ®£¬Ôò¿Éµ÷ÓÃdbms_xplan.display_cursor¡£´ÓÕâ·½Ãæ
½²£¬Ã¿Ò»¸öDBA¶¼¾ß±¸×Åдһ¸öOracleµÄ¼à¿Ø¹¤¾ßµÄÄÜÁ¦¡£ËüÓ¦¸Ã±Èдһ¸öLinuxµÄ¼à¿Ø¹¤¾ßÀ´µÃÈÝÒ×¼òµ¥µÃ¶à¡£
Èç¹û¶Ô¼à¿Ø¹¤¾ß×öÏ·ÖÀàµÄ»°£¬¿ÉÒÔ·Ö³ÉÁ½À࣬һÀàÊÇ»ùÓÚÎı¾Ä£Ê½µÄ£¬Ò»ÀàÊÇ»ùÓÚGUIģʽµÄ¡£´ó²¿·ÖDBA¶¼×Ô¼ºÊÕ¼¯ÁËһЩºÜ³£¼ûµÄ¼à¿Ø½Å±¾£¬ÎÒÏë
¿ÉÒÔ°ÑÕâÒ»Àà¹éΪ»ùÓÚÎı¾Ä£Ê½µÄ¹¤¾ß¡£Îı¾Ä£Ê½µÄºÃ´¦ÔÚÓÚÇáÁ¿¼¶£¬·´Ó¦Ëٶȿ죬±È½ÏÊʺÏÔÚshellģʽϺÍsqlplusЭͬ¹¤×÷¡£´ó²¿·ÖDBA¿ÉÄÜÒ²
±È½ÏÏ°¹ßÕâ¸öģʽ£¬°üÀ¨ÎÒÔÚÄÚ¡£
GUIģʽÓõý϶àµÄ¹¤¾ßÓ¦¸ÃÊÇToad¡£ºÜ²»´íµÄÒ»¸ö¹¤¾ß£¬ÓÃËüÀ´¼à¿Øsessions£¬sessionÕýÔÚÖ´ÐеÄÓï¾ä£¬sessionµÄµÈ´ýʼþÊÇÎÒ×î³£ÓõÄÒ»¸ö¹¦ÄÜ¡£
Ò²ÓÐһЩºóÆðÖ®Ð㣬Óиö¹¤¾ßÒ²ÐíÖµµÃÒ»Ìᣬ½Ð×öDB Optimizer
¡£×îÖ÷ÒªµÄÊÇÕâ¸ö²úÆ·µÄÖ÷Òª²ÎÓëÕߣº²ÎÓëÁË10g EMÀïµÄPerformance PageµÄÖØÐÂÉè¼ÆµÄKyle Hailey
¡£ÒÔÒ»¸ö½Øͼ×öΪ½áβ°É:
±¾ÎÄת×Ô£ºhttp://www.os2ora.com/oracle-monitoring-tool-summary-and-recommend/


Ïà¹ØÎĵµ£º

oracle·þÎñÆ÷ÅäÖü°ÓÅ»¯

1.ÔÚORACLEÖÐʵÏÖ·Ö²¼Ê½¿ìËÙ´æÈ¡ºÍ³äʵÄÚ´æÊǺÜÖØÒªµÄ¡£
¡¡¡¡
¡¡¡¡Òª²»Ï§Èκδú¼Û±ÜÃâÒ³Ãæµ÷¶ÈºÍ½»»»﹐ÿ´Î¶¼±ØÐë°Ñϵͳȫ¾ÖÇø(SGA)·Åµ½ÄÚ´æ¡£
¡¡¡¡
¡¡¡¡½«SGA·Åµ½ÄÚ´æÖÐ﹐ÔÚINIT.ORAÖÐÉèÖòÎÊý PRE_PAGE_SGA
¡¡¡¡
¡¡¡¡PRE_PAGE_SGA=YES
¡¡¡¡
¡¡¡¡2.»Ø¾í¶ÎµÄ¾¹Õù»á½µµÍϵͳµÄÐÔÄÜ¡£
¡¡¡¡
¡¡¡¡SELECT¡ ......

½âËø±í(oracle)

µ±Ê¹ÓÃ'for update' Ôì³É±íËøסÁË.¿ÉÒÔÓÃDBAµÇ½°´ÕÕÏÂÃæ²½Öè:
1.²é¿´Äĸö±í±»Ëø:
select b.owner,b.object_name,l.session_id,l.locked_mode
from v$locked_object l, dba_objects b
where b.object_id=l.object_id;
2.²é¿´±»Ëø±íµÄsid ºÍserial# :
select t2.username,t2.sid,t2.serial#,t2.logon_time
from v$lo ......

OracleÖйúCEOºú²®ÁÖ£º¹ÜÀí¾ÍÊǹµÍ¨

¶Ôºú²®ÁֵIJɷÃÈçÆÚÔÚλÓÚ±±¾©¹úóµÄOracleÖйú×ܲ¿½øÐУ¬µ±¼ÇÕß°Ñ×¼±¸ºÃµÄ²É·ÃÌá¸ÙµÝ¸øºú²®ÁÖÖ⣬ÒÔΪËû»áÏñÐí¶àÊÜ·ÃÕßÒ»ÑùÌÏÌϲ»¾øÆðÀ´£¬Ë­ÖªËûÖ»ÊÇ¿´ÁËÒ»ÑÛ˵£º“»¹ÊÇÒ»ÆðÌÖÂÛ°É£¬Îҿɲ»Ô¸³ª¶À½ÇÏ·¡£”
¡¡¡¡ÔÚOracleÖйú£¬ºú²®ÁÖÊÇÒ»¸öÇÅÁº£¬Ò»¸öÓë×ܲ¿ÓëÖйúÔ±¹¤Ö®¼ä¹µÍ¨µÄÇÅÁº£¬Ò»¸öÕ½ÂÔÖƶ¨ÓëÖ´ÐÐÖ®¼äµÄÇÅ ......

C#´¦Àíoracle lobµÄÀý×Ó

  protected void BindData1()
    {
        OracleConnection orcn = new OracleConnection("User ID=wesoftwcp; Password=wesoft; Data Source=oradb");
        orcn.Open();
      &nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ