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

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Õâ¸öÓû§£¬ÄÜ°ÑËüËùÓÐÊý¾Ý¶¼µ¼³öÂð£¿
      ¿ÉÒÔ¡£


Ïà¹ØÎĵµ£º

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

oracle¸´Ï°£¨Ò»£© Ö®OracleÌåϵ½á¹¹

      ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬Ô­À´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·­Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
      µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......

OracleµÄѧϰ·½·¨

oracleµÄÌåϵ̫ÅÓ´óÁË£¬¶ÔÓÚ³õѧÕßÀ´Ëµ£¬ÄÑÃâ»áÓÐЩÎÞ´ÓÏÂÊֵĸоõ£¬Ê²Ã´¶¼Ïëѧ£¬½á¹ûʲô¶¼Ñ§²»ºÃ£¬ËùÒÔ°Ñѧϰ¾­Ñé¹²Ïíһϣ¬Ï£ÍûÈøոÕÈëÃŵÄÈ˶ÔoracleÓÐÒ»¸ö×ÜÌåµÄÈÏʶ£¬ÉÙ×ßһЩÍä·¡£
 
Ò»¡¢¶¨Î»
oracle·ÖÁ½´ó¿é£¬Ò»¿éÊÇ¿ª·¢£¬Ò»¿éÊǹÜÀí¡£¿ª·¢Ö÷ÒªÊÇдд´æ´¢¹ý³Ì¡¢´¥·¢Æ÷ʲôµÄ£¬»¹ÓоÍÊÇÓÃOracleµÄDevel ......

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.T ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ