oracleһЩ²Ù×÷

1.²é¿´±í¿Õ¼ä:
SELECT A.TABLESPACE_NAME,A.BYTES TOTAL,B.BYTES USED, C.BYTES FREE,
(B.BYTES*100)/A.BYTES "% USED",(C.BYTES*100)/A.BYTES "% FREE"
from SYS.SM$TS_AVAIL A,SYS.SM$TS_USED B,SYS.SM$TS_FREE C
WHERE A.TABLESPACE_NAME=B.TABLESPACE_NAME AND A.TABLESPACE_NAME=C.TABLESPACE_NAME;
 2.µ±oracleËÀÁ˵ÄʱºòµÄ²Ù×÷:
ÖÕÖ¹ÓëORACLE_SIDÓйصÄËùÓÐOracle¹ý³Ì.                                                                     
ÓÃipcs –pmbÃüÁîÀ´Ê¶±ðËùÓÐÕ¼ÓõÄRAMÄÚ´æƬ¶Ï¡£
ÓÃipcrm -m ÃüÁîÀ´´ÓUNIXÖÐÊÍ·ÅÕ¼ÓõÄRAMÄÚ´æ¡£                                                
Ö»¶ÔNon-AIX£ºÓÃipcs -saÃüÁîÀ´ÏÔʾռÓñê¼Ç£¬ÓÃipcrm –sÃüÁîÀ´ÊͷŸÃʵÀýµÄÕ¼Óñê¼Ç                                      
´´½¨µ¥Ò»ÃüÁîÀ´ÖÕÖ¹Óë¹ÒÆð£¨hung£©µÄÊý¾Ý¿âʵÀýÓйصÄOracle¹ý³ÌÊǺܼòµ¥µÄ¡£ÔÚÏÂÃæµÄÀý×ÓÖ®ÖУ¬
ÎÒÃÇÓÃpsÖ¸ÁîÀ´Ê¶±ðOracle¹ý³Ì£¬È»ºóÓÃawk³ÌÐòÀ´»ñÈ¡Oracle¹ý³ÌµÄ¹ý³ÌID£¨process ID£¬PID£©¡£
È»ºó£¬ÎÒÃǰѹý³ÌIDÊäÈëµ½UNIXµÄkillÃüÁîÖ®ÖС£
oracleÓû§> ps -ef|grep $ORACLE_SID| grep -v \ grep|awk '{print $2}'|xargs -i kill -9 {}
ÔÚÖÕÖ¹ËùÓÐOracle¹ý³ÌÖ®ºó£¬ÎÒÃÇ¿ÉÒÔÓÃipcs –pmbÖ¸ÁîÀ´¼ì²éÕ¼ÓõÄÄÚ´æ²¢Çå³ýÊý¾Ý¿âËùÕ¼ÓõÄÄÚ´æ¡£
ÎÒÃÇÊ×ÏÈÏÔʾ³öÊý¾Ý¿â·þÎñÆ÷ÉÏËùÓÐÕ¼ÓÃÄڴ棺
IPC