OracleÖбí¿Õ¼äÊÇÓɶΣ¨segment£©×é³ÉµÄ£¬¶ÎÊÇÓÉÇø×é³ÉµÄ£¬±í¿Õ¼ä¿ÉÒÔ´´½¨¡¢Ð޸ġ¢É¾³ý£¬ÄÇô¶Î¿É²»¿ÉÒÔ´´½¨¡¢Ð޸ġ¢É¾³ý£¿Èç¹û¿ÉÒÔ£¬ÈçºÎ£¿ »¹ÓУ¬¶ÎºÍtableÓÐʲô¹ØÏµ£¿
Oracle.¶Î¡¢Çø¼äºÍÊý¾Ý¿é
Êý¾Ý¿âµÄ¶ÎÊÇÓÉÈô¸É¸öÇø¼ä×é³ÉµÄ£¬Çø¼äÖÐÊÇһЩÁ¬ÐøµÄÊý¾Ý¿é¡£ÕâÈýÕßÊǹ¹³ÉÆäËûÊý¾Ý¶ÔÏóµÄ»ù±¾µ¥Î»
Êý¾Ý¿â¶Î:
°üÀ¨Êý¾Ý¶Î¡¢Ë÷Òý¶Î¡¢LOB¶Î¡¢Òç³ö¶Î¡¢»Ø¹ö¶ÎºÍÁÙʱ¶Î
Çø¼ä(Extent):
±í¿Õ¼äÄÚÁ¬Ðø·ÖÅäµÄÏàÁÚµÄÊý¾Ý¿é£¬½Ð×öÇø¼ä¡£±íµÄÇø¼äÏÞÖÆÔÚ10000ÒÔÄÚ£¬¾ø´ó¶àÊýµÄÊý¾Ý¿âÄÜÔËÐеĺܺá£
Êý¾Ý¿é(Data Block):
Êý¾Ý¿éÊÇÊý¾Ý¿âÖÐ×îС¡¢×î»ù±¾µÄ´æ´¢µ¥Ôª¡£Êý¾Ý¿éµÄ´óС±ØÐëÊÇ·þÎñÆ÷²Ù×÷ϵͳ¿éµÄ´óСµÄÕûÊý±¶¡£Ï໥Á¬ÐøµÄÊý¾Ý¿é½Ð×öÁ´½Ó£¬¶à¹ýµÄI/O²Ù×÷»á½µµÍϵͳµÄÐÔÄÜ£¬Òò´ËÒª¾¡Á¿±ÜÃâÁ´½Ó¡£
Oracle ¶Î£¨segment£©¡¢·¶Î§£¨extend£©¡¢Êý¾Ý¿é£¨data block£©2009-04-23 15:18¶Î¡¢·¶Î§ºÍÊý¾Ý¿é
ORACLEͨ¹ý¶Î¡¢·¶Î§ºÍÊý¾Ý¿éÂß¼Êý¾Ý½á¹¹¿É¸üϸµØ¿ØÖÆ´ÅÅ̿ռäµÄʹÓá£
¶Î
¶Î£¨SEGMENT£©°üº¬±í¿Õ¼äÖÐÒ»ÖÖÖ¸¶¨ÀàÐ͵ÄÂß¼´æ´¢½á¹¹£¬ÊÇÓÉÒ»×鷶Χ×é³É¡£ÔÚORACLEÊý¾Ý¿âÖÐÓм¸ÖÖÀàÐ͵ĶΣºÊý¾Ý¶Î¡¢Ç£Òý¶Î¡¢»Ø¹ö¶ÎºÍÁÙʱ¶Î¡£
Êý¾Ý¶Î£º¶ÔÓÚÿһ¸ö·Ç¾Û¼¯µÄ±íÓÐÒ»Êý¾Ý¶Î£¬±íµÄËùÓÐÊý¾Ý´æ·ÅÔڸöΡ£Ã¿Ò»¾Û¼¯ÓÐÒ»¸öÊý¾Ý¶Î£¬¾Û¼¯ÖÐÿһ¸ö±íµÄÊý¾Ý´æ´¢ÔڸöÎÖС£
Ë÷Òý¶Î£ºÃ¿Ò»¸öË÷ÒýÓÐÒ»Ë÷Òý¶Î£¬´æ´¢Ë÷ÒýÊý¾Ý¡£
»Ø¹ö¶Î£ºÊÇÓÉDBA½¨Á¢£¬ÓÃÓÚÁÙʱ´æ´¢Òª³·ÏûµÄÐÅÏ¢£¬ÕâЩÐÅÏ¢ÓÃÓÚÉú³É¶ÁÒ»ÖÂÐÔÊý¾Ý¿âÐÅÏ¢¡¢ÔÚÊý¾Ý¿â»Ö¸´Ê±Ê¹ÓᢻعöδÌá½»µÄÊÂÎñ¡£
ÁÙʱ¶Î£ºµ±Ò»¸öSQLÓï¾äÐèÒªÁÙʱ¹¤×÷ÇøÊ±£¬ÓÉORACLE½¨Á¢¡£µ±Óï¾äÖ´ÐÐÍê±Ï£¬ÁÙʱ¶ÎµÄ·¶Î§Í˻ظøÏµÍ³¡£
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿
3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......