Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

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×îÐÂÈÏÖ¤Ìâ¿â×ÊÁÏÏÂÔØ
Actualtests Oracle 1Z0-200 V11.07.08
Actualtests Oracle 1Z0-211 V11.10.08
Actualtests Oracle 1Z0-212 V11.07.08
Actualtests Oracle 1Z0-213 V11.07.08
Actualtests Oracle 1Z0-101 V11.07.08
Actualtests Oracle 1Z0-132 V11.07.08
Actualtests Oracle 1Z0-140 V11.21.08
Actual ......

Oracle JOB Ó÷¨Ð¡½á£¨×ªÔØ£©

 Oracle JOB Ó÷¨Ð¡½á
Ò»¡¢ÉèÖóõʼ»¯²ÎÊý job_queue_processes
¡¡¡¡sql> alter system set job_queue_processes=n;£¨n>0£©
¡¡¡¡job_queue_processes×î´óֵΪ1000
¡¡¡¡
¡¡¡¡²é¿´job queue ºǫ́½ø³Ì
¡¡¡¡sql>select name,description from v$bgprocess;
¡¡¡¡
¡¡¡¡¶þ£¬dbms_job package Ó÷¨½éÉÜ
¡¡¡¡ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ