2020Äê7ÔÂ21ÈÕ

ÕªÒª£º parameter: instance_name Ψһ±êʶÁËÒ»¸öʵÀý£¬×î¶à255¸ö×Ö·û£¬¿ÉÒÔÓÐÏ»®Ïߣ¬Ò»°ãÇé¿öÏÂÓëORACLE_SIDÏàͬ£¬µ«ÊÇÒ²¿ÉÒÔ²»Í¬£¬ÓÃÓÚÅäÖÃÁ¬½Ó´®£¬×¢²á¼àÌý£¬ÓÃÓÚÍⲿÁ¬½Ó¡£¿ÉÒÔͨ¹ýshow parameter instance_name²é¿´ ORACLE_SID£º SID±êʶ ÔĶÁÈ«ÎÄ
posted @ 2020-07-21 17:09 Nathan-wang ÔĶÁ(295) ÆÀÂÛ(0) ÍƼö(0) ±à¼­
 
ÕªÒª£º Ç°ÑÔ£º Ê×ÏÈ£¬Õâ´Î¹ÊÕϵ߸²ÁËa56爆大奖在线娱乐¶ÔOracleµÄÈÏÖª£¬ÔÚ±ÊÕßµÄÒ»¹áÈÏÖªÖУ¬OracleÊÇÍêÈ«¿É¿¿µÄ£¬Ö»ÒªÊý¾Ý²»Ë𻵣¬ËûÄÜ´ÓÈa56爆大奖在线娱乐âµÄµôµç£¬å´»úµÈÒì³£×´¿öÏ»ָ´£¬¶øredoºÍundoµÄ´æÔÚ£¬²»»áÈÃÓû§³öÏÖÔà¶ÁºÍ´í¶ÁµÄÇé¿ö¡£ µ«´Ë´ÎµÄ¹ÊÕÏ£¬ÈÃa56爆大奖在线娱乐¶ÔOÊÂÎñ´¦ÀíµÄÁ÷³Ì²úÉúÁËÒ»¶¨µÄ»³ÒÉ£¬ÊÂÎñµÄÔ­×ÓÐÔ¡¢Ò»ÖÂÐÔ¡¢¸ôÀëÐÔ¡¢ ÔĶÁÈ«ÎÄ
posted @ 2020-07-21 14:59 Nathan-wang ÔĶÁ(838) ÆÀÂÛ(0) ÍƼö(0) ±à¼­
 
ÕªÒª£º ʵ¼Êµ±Ç°ÊÂÎñÕýÔÚʹÓõÄUNDO¿Õ¼ä UNDO¶Î·ÖÅäΪ¶à¸öÊÂÎñʹÓà select XIDUSN,USED_UBLK*(select value from v$parameter where name='db_block_size')/1024/1024 undo_MB,to_char(sysdate, ÔĶÁÈ«ÎÄ
posted @ 2020-07-21 09:49 Nathan-wang ÔĶÁ(431) ÆÀÂÛ(0) ÍƼö(0) ±à¼­