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

Oracle ¶Î Çø ¿é

ÔĶÁoracleÎĵµµÄb10743£¬¡¶conceps¡·¡£Õâ±¾±»oracle¹«Ë¾µÄ´óʦ¼¶µÄÈËÎïMichele CyranµÈÅ£ÈËËùд£¬ÕæÊÇÒ»±¾²»´íµÄÊé¼®¡£¿É̾ӢÎIJ»Ì«ºÃ£¬µ«Å¬Á¦£¬×Ü»áÓÐÊÕ»ñµÄ¡£»¹ÊÇ´ÓËûµÄÊý¾Ý¼Ü¹¹À´Ëµ°É£¡
 £¨Ò»£©Data blocks £¬Extents£¬Segment
    Õâ¾ÍÊÇËûÃÇÖ®¼äµÄÂß¼­½á¹¹¡£
    ÏÈ¿´Data blocks£¨Ò²½ÐÂß¼­¿é£¬oracle¿é£¬Ò³£©°É£¬oracle´æ´¢Êý¾Ý¶¼ÊÇÔÚÕâЩÊý¾Ý¿éÖУ¬Ò»¸öÊý¾Ý¿éÊÇ´ÅÅÌÉÏÊý¾Ý¿âÎïÀí¿Õ¼äһϵÁÐÎïÀí×Ö½ÚµÄ×é³É¡£
    ±ÈData blocks¸ü¸ßÒ»²ãµÄÂß¼­Êý¾Ý¿é¿Õ¼äÊÇextent£¬Ò»¸öextentÊÇÓÉһϵÁÐÁÙ½üµÄ´æ´¢ÐÅÏ¢µÄÊý¾Ý¿é×é³É¡£
    ×î¸ßÒ»²ãµÄÂß¼­½á¹¹ÊÇsegment£¬Ò»¸ösegmentÊÇͬһ±í¿Õ¼äextentsµÄÒ»¸ö¼¯ºÏ¡£Ã¿Ò»¸ösegmentÓв»Í¬µÄÊý¾Ý½á¹¹¡£Èçÿһ¸ö±íµÄÊý¾Ý¾Í´æ´¢ÔÚ×Ô¼ºµÄdata segment£¬Ã¿Ò»¸öË÷Òý´æ´¢ÔÚ×Ô¼ºµÄË÷Òý¶Î£¬Èç¹û±í»òÕßË÷ÒýÊÇ
ÊÇ·ÖÇø´æ´¢µÄ£¬ÄÇôÿһ¸ö·ÖÇø¶¼´æ´¢ÔÚËûÃǸ÷×ÔµÄsegmentÖС£Ò»¸ösegmentºÍËûËùÓеÄextent¶¼ÊÇÔÚÒ»¸ö±í¿Õ¼äÖУ¬²¢ÇÒÒ»¸ösegment¿ÉÒÔ¿çÔ½¼¸¸öÊý¾ÝÎļþ¡£¡£
    ¶ÔÓÚÊý¾Ý¿âÀ´Ëµ£¬data blockÊÇoracleÊý¾Ý¿âÖзÖÅäºÍ˽ÓõÄ×îС´æ´¢µ¥Ôª¡£µ«Õâ½ö½ö¶ÔÊý¾Ý¿âÀ´Ëµ£¬ÔÚÎïÀí²ã´Î£¬²Ù×÷ϵͳ²ã´Î£¬ËùÓеÄÊý¾ÝÈÔ¾ÉÊÇ°´×Ö½Ú´æ´¢µÄ¡£Ã¿Ò»¸ö²Ù×÷ϵͳ¶¼ÓÐ×Ô¼ºµÄ¿é³ß´ç£¨block size£©£¬ÔÚoracleÊý¾Ý¿âÖУ¬Êý¾Ý¿éµÄ´óС¶¼ÓвÎÊýdb_block_sizeÔÚ´´½¨Êý¾Ý¿âµÄʱºòÀ´È·¶¨£¬ËûµÄÊýÖµÓ¦¸ÃÊDzÙ×÷ϵͳ¿é³ß´çµÄÕûÊý±¶¡£
    Êý¾Ý¿é¶¼ÓÐÕâô¼¸²¿·Ö×é³É£¬¿éÍ·²¿·Ö£¬±íĿ¼£¬ÐÐĿ¼£¬¿ÕÏпռ䣬Êý¾ÝÕ⼸²¿·Ö×é³É¡£¿éÍ·Ö÷Òª°üº¬Á½²¿·ÖÐÅÏ¢£º¿éÍ·µØÖ·ºÍsegmentµÄÀàÐÍ£¬ÊÇÊý¾Ý±í»¹ÊÇË÷Òý£»±íĿ¼Ö÷Òª°üº¬¿éÖÐÓжàÉÙÐÐÊý¾Ý¡£ÐÐĿ¼Ö÷Òª°üº¬Ã¿Ò»ÐеÄÎïÀíµØÖ·¡£Êý¾Ý¾ÍºÜÃ÷ÏÔÁË£¬¾ÍÊÇÕâ¸ö¿é°üº¬µÄÊý¾Ý¡£ÕâÀï±ß×îÆæÃîµÄ¾ÍÊÇÕâ¸ö¿ÕÏпռ䣬ËüÖ÷ҪĿµÄ¾ÍÊÇΪvarcharÕâ¸öÊý¾ÝÀàÐÍ×¼±¸µÄ£¬ÓÐÁ½¸öãÐÖµ²ÎÊýpctfree,pctusedÀ´¿ØÖÆ´ËÊý¾Ý¿ìÒÆÏòÄÇÒ»¸öÁ´±í,ÕâÁ½¸ö²ÎÊýµÄÉ趨Ö÷ҪĿµÄÊÇΪÁ˱ÜÃâÐÐÁ¬½ÓÓëÐÐǨÒÆ£¬¾ßÌåµÄÓÖ¹»Ò»ÆªÎÄÕÂÁË£¬ÒÔºóÔÙд£¬^_^¡£
    ÔÚÀ´ËµextentÕâ¸öÓÉһϵÁÐÁ¬ÐøµÄdata blocks×é³É¡£Ã¿µ±ÔÚÊý¾Ý¿âÖд´½¨Ò»¸ö±í£¬ÄÇô·ÖÅä¸ø±íµÄdata segment·ÖÅäÒ»¸ö°üº¬Èô¸ÉÊý¾Ý¿âµÄ³õʼµÄextent£¬ËäÈ»»¹Ã»Óвå½øÈ¥Êý¾Ý£¬µ«³õʼµÄextentÒѾ­×öºÃÁ˲åÈëÊý¾ÝµÄ×¼±¸¡£Èç¹û³õʼµÄextentÖеÄÊý¾Ý¿éÒѾ­ÂúÁË£¬»òÕßûÓпռä²åÈëÊý¾Ý£¬ÄÇôËû


Ïà¹ØÎĵµ£º

Oracle Êý¾Ý¿âµÄ±¸·ÝÓë»Ö¸´£¨Âß¼­¡¢Àä¡¢ÈÈ£©

½ñÌì¿´µ½Ò»Æª¹ØÓÚORCLEµÄÂß¼­±¸·Ý£¬Àä¡¢Èȱ¸·ÝµÄÌû×Ó½²µÄͦºÃµÄ£¬²»¹ýÕâƪÎÄÕÂÊÇÒÔORACLE 7ΪÀý×Ó£¬ËäÈ»ÏÖÔÚÒѾ­ÓкܺúÜÇ¿´óµÄRMAN£¬µ«»¹ÊǾõµÃÓбØҪת¹ýÀ´£¬²»ÄÜϲÐÂÑá¾ÉÂï¡£
==================================================================================
OracleÊý¾Ý¿âµÄ±¸·ÝÓë»Ö¸´  
---- µ±ÎÒÃÇ ......

oracleÖбéÀúÊ÷ÐνṹµÄ·½·¨

 start with....connect by prior....×Ó¾ä
ÀýÈ磺employee±íÖеÄÊý¾ÝÈçÏ£º
employee_id     name    manager_id
       1                    ......

WindowsÏÂÃüÁîÐÐÆô¶¯Oracle 10g/Database Control

 
1.Æô¶¯TNS¼àÌý
C:\Documents and Settings\Administrator>lsnrctl start
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 13-7ÔÂ -2008 12:0
3:55
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Æô¶¯tnslsnr: ÇëÉÔºò...
TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Pr ......

С²ËÄñÎÊ£ºoracleÖеÄÒ»¸ö´¥·¢Æ÷ÎÊÌâ

ÎÊÌâ
£¨1£©±íemployeesºÍdepartment´æÔÚ²ÎÕÕÍêÕûÐÔÔ¼Êø£¬ÔÚ±íemployeesÖвåÈë¼Ç¼£¨‘70’£¬‘999’£©department_idΪ‘999’ʱ£¬department±íÖл¹²»´æÔÚdepartment_idΪ‘999’µÄ¼Ç¼£¬ËùÒÔÎ¥±³Á˲ÎÕÕÍêÕûÐÔÔ¼Êø,³öÏÖ“Integrity constraint violation error”ÌáʾÐÅÏ ......

Oracle²Ù×÷ϵͳÈÏÖ¤

ĬÈÏÇé¿öÏ£¬ÔÚOracleµÄÖ÷»úÉÏ£¨linuxϵͳ£©µÄOracle²Ù×÷ϵͳÓû§Ï£¬ÒÔsysÓû§µÇ½Êý¾Ý¿âʱ¿ÉÒÔ²»ÓÃÊäÈëÃÜÂëÖ±½ÓµÇ¼¡£Êµ¼ÊÉÏ£¬Ö»ÒªÊÇÊôÓÚdba×飨linux£©»òosdba×飨windows£©Ï£¬¶¼¿ÉÒÔ²»ÓÃÃÜÂë½øÐеǼ¡£ÕâÊÇÈÏÖ¤·½Ê½³ÆΪOSÈÏÖ¤¡£
ÕâÖֵǼ·½Ê½µÄ¿ØÖÆ£¬ÊÇͨ¹ý$ORACLE_HOME/network/admin/sqlnet.oraÖеģº
SQLNET.AUTH ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ