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ÖеÄÊý¾Ý¿éÒѾÂúÁË£¬»òÕßûÓпռä²åÈëÊý¾Ý£¬ÄÇôËû
Ïà¹ØÎĵµ£º
½ñÌì¿´µ½Ò»Æª¹ØÓÚORCLEµÄÂß¼±¸·Ý£¬Àä¡¢Èȱ¸·ÝµÄÌû×Ó½²µÄͦºÃµÄ£¬²»¹ýÕâƪÎÄÕÂÊÇÒÔORACLE 7ΪÀý×Ó£¬ËäÈ»ÏÖÔÚÒѾÓкܺúÜÇ¿´óµÄRMAN£¬µ«»¹ÊǾõµÃÓбØҪת¹ýÀ´£¬²»ÄÜϲÐÂÑá¾ÉÂï¡£
==================================================================================
OracleÊý¾Ý¿âµÄ±¸·ÝÓë»Ö¸´
---- µ±ÎÒÃÇ ......
start with....connect by prior....×Ó¾ä
ÀýÈ磺employee±íÖеÄÊý¾ÝÈçÏ£º
employee_id name manager_id
1   ......
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 ......
ÎÊÌâ
£¨1£©±íemployeesºÍdepartment´æÔÚ²ÎÕÕÍêÕûÐÔÔ¼Êø£¬ÔÚ±íemployeesÖвåÈë¼Ç¼£¨‘70’£¬‘999’£©department_idΪ‘999’ʱ£¬department±íÖл¹²»´æÔÚdepartment_idΪ‘999’µÄ¼Ç¼£¬ËùÒÔÎ¥±³Á˲ÎÕÕÍêÕûÐÔÔ¼Êø,³öÏÖ“Integrity constraint violation error”ÌáʾÐÅÏ ......
ĬÈÏÇé¿öÏ£¬ÔÚOracleµÄÖ÷»úÉÏ£¨linuxϵͳ£©µÄOracle²Ù×÷ϵͳÓû§Ï£¬ÒÔsysÓû§µÇ½Êý¾Ý¿âʱ¿ÉÒÔ²»ÓÃÊäÈëÃÜÂëÖ±½ÓµÇ¼¡£Êµ¼ÊÉÏ£¬Ö»ÒªÊÇÊôÓÚdba×飨linux£©»òosdba×飨windows£©Ï£¬¶¼¿ÉÒÔ²»ÓÃÃÜÂë½øÐеǼ¡£ÕâÊÇÈÏÖ¤·½Ê½³ÆΪOSÈÏÖ¤¡£
ÕâÖֵǼ·½Ê½µÄ¿ØÖÆ£¬ÊÇͨ¹ý$ORACLE_HOME/network/admin/sqlnet.oraÖеģº
SQLNET.AUTH ......