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

oracleËéÆ¬Ð¡½á

author£ºskate
time£º2010-05-31
ÎÒÃÇÔÚʹÓÃwindowsµÄʱºò£¬¶¼ÖªµÀÒª¶¨ÆÚÕûÀí´ÅÅÌË鯬£¬ÒòΪ´ÅÅÌË鯬»áÓ°ÏìÐÔÄÜ£¬¸ø¹ÜÀíÉÏ´øÀ´¶îÍâµÄ
¸ºµ£¡£ÄÇoracle¸üÊÇÈç´Ë£¬µ±Ëæ×ÅÊý¾ÝÔö¼Ó£¬oracle´¦Àíº£Á¿Êý¾Ý±¾Éí¾ÍÒѾ­ºÜ·ÑÁ¦Á˰¡£¬Èç¹ûÔÙÓдóÁ¿
µÄË鯬£¬ÄǾÍÊÇÑ©ÉϼÓ˪°¡¡£ËùÒÔËéÆ¬ÒªÒýÆðdbaµÄ¸ß¶ÈÖØÊÓ£¬¾¡Ôç·¢ÏÖ¾¡Ôç´¦Àí¡£
Ë鯬ÊÇÔõô²úÉúµÄÄØ£¿
¼òµ¥Àí½â¾ÍÊÇÓÉÓÚ¸üкÍɾ³ý²úÉúһЩËéСµÄ²»Äܱ»ÔÙ´ÎʹÓõĿռ䣬¸ù¾ÝÿÖÖ²»Í¬µÄË鯬ËûÃǵIJúÉúÒ²ÊÇÓÐÇø±ðµÄ
block-levelµÄË鯬£¬¶øblockÓÖ·ÖΪdata blockºÍindex block£¬ÔÚdata blockÖдæ·ÅµÄÊÇrowÊý¾Ý£¬ÔÚindex block
Öдæ·ÅµÄÊÇË÷Òý¼üÖµÊý¾Ý£¬ËùÒÔ°´ÉÏÃæËù˵£¬block-levelË鯬ÓÐϸ·ÖΪrow-levelË鯬ºÍIndex Leaf Block-levelË鯬¡£
oracleµÄÿһ¸ö¶ÔÏó¶¼ÊÇ´æ´¢ÔÚsegmentÖУ¬¶øoracleµÄ×îС·ÖÅ䵥λÊÇextents£¨Çø£©£¬ÔÚÊý¾Ý¸üÐÂɾ³ýÖÐÒ²»á²úÉúË鯬
ÕâÒ»¼¶±ðµÄË鯬¾ÍÊÇsegmentË鯬¡£segmentÓÖ´æÔÚdatafileÖУ¬¶øtablespaceÓÖÊǰüº¬datafileµÄÂß¼­¸ÅÄî¡£ËùÒÔÕâÒ»²ã
ÊÇtablespace-levelË鯬£»tablespaceÊÇÔÚdiskÉÏ´æ´¢£¬ËùÒÔÕâÒ»²ã¾ÍÊÇdisk-levelË鯬¡£
¼òµ¥Í¼Ê¾ÈçÏÂ
disk-level fragmention
  tablespace-level fragmentation
    segment-level fragmentation
      block-level fragmentation
        row-level fragmentation
      index leaf block-level fragmentation
˳±ãÌáÏÂoracle extents´æÔÚµÄÀíÓÉ
Ò»¸öextentsÊÇÓɶà¸öÏàÁ¬µÄblock×é³ÉµÄ£¬¶à¸öextents×ö³ÉÒ»¸ösegment£»extentÊÇoracleµÄ×îС·ÖÅ䵥λ
extentµÄÓŵ㣺
1. Ìá¸ß¿Õ¼ä·ÖÅ䣬ÊͷŵÄЧÂÊ£¬½µµÍ¹ÜÀíblockµÄ×ÊÔ´³É±¾
2. Ìá¸ßɨÃèµÄЧÂÊ£¬ÒòΪextentÊÇÓÉÏàÁ¬blocks×ö³ÉµÄÌØÐÔ£¬¿ÉÒÔÒ»´Î¶ÁÈ¡¸ü¶àµÄÄÚÈÝ£¬½ÏµÍio¶Áд´ÎÊý
extentµÄȱµã
ÈÝÒײúÉúË鯬
ÈçºÎÈ·¶¨²úÉúÁËË鯬µÄÄØ£¿
Ò»¡£±í¿Õ¼äËéÆ¬È·¶¨²Î¿¼
ÓÉÓÚ×ÔÓɿռäË鯬ÊÇÓɼ¸²¿·Ö×é³É£¬È緶ΧÊýÁ¿¡¢×î´ó·¶Î§³ß´çµÈ£¬ÎÒÃÇ¿ÉÓà FSFI--Free Space Fragmentation Index
(×ÔÓɿռäË鯬Ë÷Òý)ÖµÀ´Ö±¹ÛÌåÏÖ£º
¡¡¡¡FSFI=100*SQRT(max(extent)/sum(extents))*1/SQRT(SQRT(count(extents)))
¿ÉÒÔ¿´³ö£¬FSFI µÄ×î´ó¿ÉÄÜֵΪ 100 (Ò»¸öÀíÏëµÄµ¥Îļþ±í¿Õ¼ä)¡£Ëæ×Å·¶Î§µÄÔö¼Ó£¬ FSFI Öµ»ºÂýϽµ£¬¶øËæ×Å×î´ó·¶
Χ³ß´çµÄ¼õÉÙ£¬FSFI Öµ»áѸËÙϽµ¡£Í¨¹ýÈçÏÂÓï¾ä²éѯF


Ïà¹ØÎĵµ£º

Oracle¶àÐмǼºÏ²¢/Á¬½Ó/¾ÛºÏ×Ö·û´®µÄ¼¸ÖÖ·½·¨

ʲôÊǺϲ¢¶àÐÐ×Ö·û´®£¨Á¬½Ó×Ö·û´®£©ÄØ£¬ÀýÈ磺
SQL> desc test;
Name     Type          Nullable Default Comments
------- ------------ -------- ------- --------
COUNTRY VARCHAR2(20) Y       &nb ......

oracle »ØÍ˶Îά»¤

»Ø¹ö¶ÎÓÃÓÚ¶ÔÊý¾Ý¿âÐÞ¸Äʱ, ±£´æÔ­ÓеÄÊý¾Ý, ÒÔ±ãÉÔºó¿ÉÒÔͨ¹ýʹÓÃROLLBACKÀ´»Ö¸´µ½ÐÞ¸ÄǰµÄÊý¾Ý; ÁíÍâ, »Ø¹ö¶Î¿ÉÒÔΪÊý¾Ý¿âÖеÄËùÓнø³ÌÌṩ¶ÁÒ»ÖÂÐÔ. Òò´Ë, »Ø¹ö¶ÎÉèÖõĺÏÀíÓë·ñ, Ö±½ÓÓ°Ïìµ½Êý¾Ý¿âµÄÐÔÄÜ.
»Ø¹ö¶ÎµÄά»¤¼°²éѯ
(1) ´´½¨»Ø¹ö¶Î
__CREATE ROLLBACK SEGMENT RB01
__TABLESPACE RBS1
__STORAGE (
____I ......

oracle internal number Êý¾ÝÀàÐÍ´æ´¢

ת×Ô£ºhttp://ilonng.blog.sohu.com/130335741.html
   oracleµÄnumberÀàÐÍÊÇÒ»ÖÖÈí¼þÊý¾ÝÀàÐÍ£¬ÔÚoracleÈí¼þ±¾ÉíÖÐʵÏÖ£¬ÎÒÃDz»ÄÜʹÓùÌÓÐÓ²¼þ²Ù×÷½«Á½¸önumberÀàÐÍÏà¼Ó£¬ÕâÒªÔÚÈí¼þÖÐÄ£Ä⣬number ÀàÐ͵ÄÄÚ²¿±àÂëÊÇ2¡£oracle´æ´¢Ò»¸öÊýµÄʱ£¬»á´æ´¢¾¡¿ÉÄÜÉÙµÄÄÚÈÝÀ´±íʾÕâ¸öÊý£¬Îª´ËËü»á´æ´¢ÓÐЧÊý×Ö¡¢ÓÃÓÚÖ¸¶ ......

Oracle 1z0 047 Exam


Exam Number/Code : 1z0-047
Exam Name : Oracle Database SQL Expert
Questions and Answers : 278 Q&As
Update Time: 2010-04-15
1. Which two statements are true regarding the execution of the correlated subqueries? (Choose two.)
A. The nested query executes after the outer query returns th ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ