OracleÖÐÊý¾Ý¿âÓû§ºÍ±í¿Õ¼ä¹Øϵ
Ò»¸öÓû§¿ÉÒÔʹÓÃÒ»¸ö»ò¶à¸ö±í¿Õ¼ä£¬Ò»¸ö±í¿Õ¼äÒ²¿ÉÒÔ¹©¶à¸öÓû§Ê¹Óá£Óû§ºÍ±í¿Õ¼äûÓÐÁ¥Êô¹Øϵ£¬±í¿ÕÊÇÒ»¸öÓÃÀ´¹ÜÀíÊý¾Ý´æ´¢Âß¼¸ÅÄ±í¿Õ¼äÖ»ÊǺÍÊý¾ÝÎļþ·¢Éú¹Øϵ£¬Êý¾ÝÎļþÊÇÎïÀíµÄ£¬Ò»¸ö±í¿Õ¼ä¿ÉÒÔ°üº¬¶à¸öÊý¾ÝÎļþ£¬¶øÒ»¸öÊý¾ÝÎļþÖ»ÄÜÁ¥ÊôÒ»¸ö±í¿Õ¼ä¡£
Óû§ÊôÓÚÊý¾Ý¿âʵÀýµÄ£¬ÔÚÒ»¸öʵÀýϲ»ÄÜͬÃûÓû§¡£µ«ÔÚÒ»oracle·þÎñÆ÷£¬¿ÉÒÔ´´½¨¶à¸öʵÀý£¬Ö»ÒªÄãµÄ»úÆ÷ÅäÖù»ÓþͿÉÒÔ¡£ÒòΪһ¸öʵÀýÆô¶¯ÆðÂëÐèÒª100¶àÕ×ÄÚ´æµÄ¡£ËùÒÔÔÚÒ»oracle·þÎñÆ÷ÉÏ¿ÉÒÔ´æÔÚ¶à¸öͬÃûÓû§£¬ËûÃÇÊÇÊôÓÚ²»Í¬Êý¾Ý¿âʵÀý£¬ËûÃǶÔӦʹÓõıí¿Õ¼äÔÚ²»Í¬µÄʵÀýÉÏ¡£
²éѯ±í¿Õ¼äºÍÓû§Ö®¼äµÄ¹Øϵ£º
SELECT from DBA_SEGMENTS WHERE TABLESPACE_NAME=?
FAQ:
ÔÚOracleÖн¨Á¢ÁËÒ»¸öÓû§UB£¬ËüµÄĬÈϱí¿Õ¼äÊÇTSA£¬ÔÚÊý¾Ý¿âÓÃÁËÒ»¶Îʱ¼äºó£¬·¢ÏÖÔÀ´¸ã´íÁË£¬°ÑĬÈϱí¿Õ¼ä¸Ä³ÉTSB¡£ÏÖÔÚÏëÎʼ¸¸öÎÊÌâ:
1.Êý¾Ý¾¿¾¹·ÅÔÚÄǸö±í¿Õ¼äÉÏÁË£¿
¸ü¸ÄÒÔÇ°µÄ·ÅÔÚtsaÀïÃ棬ºóÀ´µÄ·ÅÔÚtsbÀïÃæ
2.ÎÒÏë°ÑÊý¾Ý¶¼·Å»Ø±í¿Õ¼äTSBÉÏ¿ÉÒÔÂð£¿
½«±íb´æ·ÅÔÚtsaÀïÃæ --alter table b move tablespace tsb;
3.ÔõÑù²ÅÖªµÀÊý¾Ý±í·ÅÔÚÄĸö±í¿Õ¼äÉÏ£¿
select table_name,TABLESPACE_NAME from user_tables;
4.ÎÒÓÃExp À´µ¼³öUBÕâ¸öÓû§£¬ÄÜ°ÑËüËùÓÐÊý¾Ý¶¼µ¼³öÂð£¿
¿ÉÒÔ¡£
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
oracleµÄÌåϵ̫ÅÓ´óÁË£¬¶ÔÓÚ³õѧÕßÀ´Ëµ£¬ÄÑÃâ»áÓÐЩÎÞ´ÓÏÂÊֵĸоõ£¬Ê²Ã´¶¼Ïëѧ£¬½á¹ûʲô¶¼Ñ§²»ºÃ£¬ËùÒÔ°Ñѧϰ¾Ñé¹²Ïíһϣ¬Ï£ÍûÈøոÕÈëÃŵÄÈ˶ÔoracleÓÐÒ»¸ö×ÜÌåµÄÈÏʶ£¬ÉÙ×ßһЩÍä·¡£
Ò»¡¢¶¨Î»
oracle·ÖÁ½´ó¿é£¬Ò»¿éÊÇ¿ª·¢£¬Ò»¿éÊǹÜÀí¡£¿ª·¢Ö÷ÒªÊÇдд´æ´¢¹ý³Ì¡¢´¥·¢Æ÷ʲôµÄ£¬»¹ÓоÍÊÇÓÃOracleµÄDevel ......
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.T ......