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

OracleÖжÎ

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 webµÇ½EMµÄÎÊÌ⣿ - Oracle / »ù´¡ºÍ¹ÜÀí

°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿

1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......

javaÔõôÁ¬½ÓOracle£¬¼±°¡ - Java / JavaÏà¹Ø

private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......

pl/sql - Oracle / ¿ª·¢

СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿

3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......

[Ô­´´] ORACLE Á¬½Ó×Ö´® - Oracle / ·Ç¼¼ÊõÇø

¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰 
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ