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
Ïà¹ØÎĵµ£º
ʲôÊǺϲ¢¶àÐÐ×Ö·û´®£¨Á¬½Ó×Ö·û´®£©ÄØ£¬ÀýÈ磺
SQL> desc test;
Name Type Nullable Default Comments
------- ------------ -------- ------- --------
COUNTRY VARCHAR2(20) Y &nb ......
oracleÖÐpro*cµÄѧϰ
¡¡Ò» Pro*C ³ÌÐò¸ÅÊö£º
1£®Ê²Ã´ÊÇPro*C³ÌÐò
ÔÚORACLEÊý¾Ý¿â¹ÜÀíºÍϵͳÖУ¬ ÓÐÈýÖÖ·ÃÎÊÊý¾Ý¿âµÄ·½·¨£»
£¨1£© ÓÃSQL*Plus£¬ ËüÓÐSQLÃüÁîÒÔ½»»¥µÄÓ¦ÓóÌÐò·ÃÎÊÊý¾Ý¿â£»
£¨2£© ÓõÚËÄ´úÓïÑÔÓ¦Óÿª·¢¹¤¾ß¿ª·¢µÄÓ¦ÓóÌÐò·ÃÎÊÊý¾Ý¿â£¬ÕâЩ¹¤¾ßÓÐSQL*froms£¬QL*Reportwriter,SQL*MenuµÈ£»
£¨3£© ÀûÓÃÔÚ ......
MS SQL ÖеÄIsNull()º¯Êý£º
IsNull ( check_expression , replacement_expression )
check_expression: ¿ÉÒÔÊÇÈκÎÀàÐÍ,½«Òª¼ì²éµÄ±í´ïʽ ²»Îª¿Õ£¬·µ»ØËü
replacement_expression: ÀàÐͱØÐëºÍcheck_expressionÏàͬ£¬check_expressionΪnull£¬·µ»ØËü
Õâ¸öº¯ÊýµÄ×÷ÓþÍÊÇ£ºÅжÏcheck_expressionÊÇ·ñΪ¿Õ£¬Îª¿Õ¾Í·µ» ......
Åú´¦Àí£¨batÎļþ£© ×Ô¶¯Æô¶¯/¹Ø±Õoracle·þÎñ
ÅжÏoracle ·þÎñ״̬
Èç¹û·þÎñ´¦ÓÚÆô¶¯×´Ì¬£¬¾Í¹Ø±Õ·þÎñ£»
Èç¹û·þÎñ´¦ÓڹرÕ״̬£¬¾ÍÆô¶¯·þÎñ¡£
@ECHO OFF
for /f "skip=3 tokens=4" %%i in ('sc query OracleServiceORCL') do set "zt=%%i" &goto :next
:next
if /i "%zt%"=="RUNNING" (
ECHO Stoping Oracle ......