ÔõôÉèÖÃ×Ô¶¯¹ÜÀíORACLE 10GÄÚ´æ
а²×°µÄORACLE 10G£¬ÏÖÔÚÎÞ·¨Í¨¹ýWEB½çÃæµÇ¼EM£¬Ôõôͨ¹ýÆäËü·½Ê½ÉèÖÃ×Ô¶¯¹ÜÀíÄÚ´æ¡£
TOAD »òÕß ÃüÁîÐÐ ÅäÖÃÒ»¸öOEMÂï SGA PGA·Ö±ð¶¼ÒªÅäÖᣠ1. ÏÖÔÚÎÞ·¨Í¨¹ýWEB½çÃæµÇ¼EM -- OEM µÄ·þÎñÆô¶¯Ã»ÓУ¿¡¡ emctl start dbconsole 2. ÔÚpfile ÀïÃæÆôÉèÖòÎÊý£º sga_target ºÍ sga_max_size¡£ Ö»Òª¸øÒ»¸ö×ÜÖµ¾Í¿ÉÒÔÁË£¬ÕâÑùOracle¾Í»áÔÚsga_target µÄ·¶Î§ÄÚ×Ô¼º¹ÜÀíSGA ÄÚ²¿¶ÔÏóµÄ´óС¡£ ±ÈÈçshare pool£¬java poolÖ®ÀàµÄ¡£ ------------------------------------------------------------------------------ Blog£º http://blog.csdn.net/tianlesoftware ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net Ïà¹ØÊÓÆµ£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx DBA1 Ⱥ£º62697716(Âú); DBA2 Ⱥ£º62697977 Ò»°ãÀ´Ëµ ORACLEʵÀýÄÚ´æ=ÎïÀíÄÚ´æ*80% ¶ÔÓÚOLTPϵͳ: PGA=ʵÀýÄÚ´æ*20% SGA=ʵÀýÄÚ´æ*80% ¶ÔÓÚOLAPϵͳ: PGA=ʵÀýÄÚ´æ*50% SGA=ʵÀýÄÚ´æ*50% »ìºÏÐÍϵͳÔÚ¶þÕßÖ®¼ä È·¶¨ÄÚ´æÈÝÁ¿ºó£¬ ¶ÔÓÚPGA£ºÊ¹ÓÃWORKAREA_SIZE_POLICYÉèÖÃΪAUT£¬±íʾPGA×Ô¶¯¹ÜÀí ÓÃPGA_AGREGGATE_TARGET²ÎÊý·ÖÅäPGA ÓÃSGA_TARGET²ÎÊý·ÖÅäSGAÄ¿±êÖµ ÓÃSGA_MAX_SIZE·ÖÅäSGA×î´óÖµÒýÓà 1. ÏÖÔÚÎÞ·¨Í¨¹ýWEB½çÃæµÇ¼EM -- OEM µÄ·þÎñÆô¶¯Ã»ÓУ¿¡¡ emctl start dbconsole 2. ÔÚpfile ÀïÃæÆôÉèÖòÎÊý£º sga_target ºÍ sga_max_size¡£ Ö»Òª¸øÒ»¸
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£ ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£ ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£ ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿ ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ.. ÒýÓà ¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql declare TYPE test_rec IS record( code varchar(10), name varchar(30) ); v_book test_rec; ......