ORACLE´æ´¢×Ó¾äµÄÓÅÏȼ¶
½ñÌìÔÚÊéÉÏ¿´µ½ÓÐÒ»¸öС½Ú½²´æ´¢×Ó¾äÓÅÏȼ¶µÄ£¬ËµÊµ»°£¬Æ½Ê±ÔÚ´´½¨¶ÔÏóµÄʱºò¼¸ºõ²»Ôõôָ¶¨´æ´¢×Ó¾äµÄ£¬Ò»°ã²ÉÓÃĬÈÏ¡£ºÇºÇ£¬¿ÉÄÜÊÇÒòΪ±È½ÏÀÁ°É£¬½ñÌì¼ÈÈ»¿´µ½ÁË£¬¾Í¼ÇÏÂÀ´£¬ÏàÐÅÒÔºó»áÓõõ½µÄ¡£
ORACLEÊý¾Ý¿âĬÈϵĴ洢²ÎÊý < ±í¿Õ¼äËù¶¨ÒåµÄ´æ´¢²ÎÊý < ¶ÎËù¶¨ÒåµÄ´æ´¢²ÎÊý
´æ´¢×Ó¾ä¿ÉÒÔÔÚ¶ÎÒ»¼¶ËµÃ÷ÒÔ¿ØÖÆÇø¶Î(EXTENT)ÔÚ¶ÎÖÐÊÇÈçºÎ·ÖÅäµÄ¡£Æä·ÖÅäÔÔòÈçÏ£º
ÈκÎÔÚ¶ÎÒ»¼¶ËµÃ÷µÄ´æ´¢²ÎÊý½«¸²¸ÇÔÚ±í¿Õ¼äÒ»¼¶Ëù¶ÔÓ¦µÄÑ¡ÏîÉèÖ㬵«ÊDZí¿Õ¼äÒ»¼¶µÄ²ÎÊýMINIMUM EXTENT»òUNIFORM SIZE³ýÍâ¡£
µ±´æ´¢²ÎÊýÔÚ¶ÎÒ»¼¶Ã»ÓÐÏÔʾµÄ¶¨Òåʱ£¬ËüÃÇĬÈÏΪ±í¿Õ¼äÒ»¼¶Ëù¶¨ÒåµÄ²ÎÊýÖµ¡£
µ±´æ´¢²ÎÊýÔÚ±í¿Õ¼äÒ»¼¶Ã»ÓÐÏÔʾµÄ¶¨Òåʱ£¬ORACLEÊý¾Ý¿âϵͳµÄĬÈϲÎÊýÖµ½«±»Ê¹Óá£
Èç¹ûÔÚ±í¿Õ¼äÒ»¼¶ÒѾ¶¨ÒåÁËMINIMUM EXTENTµÄ´óС£¬Ëü½«Ó¦ÓÃÓڸñí¿Õ¼äÖн«À´ËùÓжεÄÇø¶Î(EXTENT)µÄ·ÖÅä¡£
ijЩ´æ´¢²ÎÊý²»ÄÜÔÚ±í¿Õ¼äÒ»¼¶¶¨Ò壬ÕâЩ´æ´¢²ÎÊýÖ»ÄÜÔÚ¶ÎÒ»¼¶ËµÃ÷¡£
Èç¹û¶Ô´æ´¢²ÎÊý½øÐÐÁËÐ޸ģ¬ÐµĴ洢²ÎÊýÖ»ÊÊÓÃÓÚ»¹Ã»ÓзÖÅäµÄÇø¶Î(EXTENT)¡£
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
Oracle Stream ÅäÖÃ
»·¾³£º
OS:Redhat Linux
Oracle 10.2.0.4
source:TEST
destnation:STANDBY
==×¼±¸==
1.¹éµµÈÕÖ¾ÅäÖãº
SQL> archive log list;
Database log mode Archive Mode
Automatic archival &nbs ......
Oracle PGA²ÎÊý
PGA: ³ÌÐòÈ«¾ÖÇø£¬·þÎñÆ÷½ø³ÌʹÓõÄÄÚ´æÇøÓò£¬°üÀ¨Ìض¨·þÎñÆ÷½ø³ÌµÄÊý¾ÝºÍ¿ØÖÆÐÅÏ¢£¬ÀýÈçʹÓõIJÙ×÷ϵͳ×ÊÔ´µÈ¡£
UGA: Óû§È«¾ÖÇø£¬Ìض¨SessionʹÓõÄÄÚ´æÇøÓò£¬ÀýÈçSessionµÄSQL¹¤×÷Çø¡¢µÇ½ÈÏÖ¤ÐÅÏ¢µÈ¡£SessionµÄSQL¹¤×÷Çø´óС¶Ô²éѯÐÔÄܵÄÓ°Ïì±È½Ï¹Ø¼ü£¬shared serverģʽʱUGA´ÓSGAµÄlarge pool£¨Èç¹ ......
Ç°ÑÔ£º
sql_trace ÊÇÎÒÔÚ¹¤×÷Öо³£ÒªÓõ½µÄµ÷ÓŹ¤¾ß£¬Ïà±È½Ïstatspack ÎÒ¸üÔ¸ÒâÓÃÕâ¸ö¹¤¾ß¡£
ÒòΪÊý¾Ý¿âÂýÔÒòµÄ85%ÒÔÉÏÊÇÓÉÓÚsqlÎÊÌâÔì³ÉµÄ£¬statspackûÓÐsqlµÄÖ´Ðмƻ®¡£ÏÔʾûÓÐËüÖ±¹Û£¬·½±ã£¬¶ÔÏëÒªÕë¶ÔÐÔ²»Ç¿£¬
1£¬½éÉÜÊý¾Ý¿âµ÷ÓÅÐèÒª¾³£»áÓõ½µÄ¹¤¾ß ......
Ê×ÏÈ´´½¨Ò»¸öË÷Òý£¬È»ºó´´½¨Ò»¸ö´¥·¢Æ÷
Ë÷ÒýµÄÃû×Ö£º SEQ_tproduct
´¥·¢Æ÷µÄÃû×Ö£º addid
±íÃû£ºtproduct
×ÔÔöÁÐÃû£ºpid
create sequence SEQ_tproduct &n ......