oracleÓÅ»¯2
--¶¨ÒåÊý¾Ý¿âÁ¬½Ó·Ö·¢Æ÷
alter system set dispatchers='(PROTOCOL=TCP)(SERVICE=imapdb)(DISPATCHERS=5)(PROTOCOL=IPC)(DISPATCHERS=5)' scope=spfile;
--¶¨Òå¹²Ïí·þÎñÊý
alter system set shared_servers=20 scope=spfile;
--¶¨Òå¹²Ïí·þÎñµÄsessionÊý
alter system set shared_server_sessions=1024 scope=spfile;
--¶¨Òå×î´ó¹²Ïí·þÎñÊý
alter system set max_shared_servers=50 scope=spfile;
--¶¨ÒåÊý¾Ý¿âÈ«¾ÖÇøµÄ×î´óÄÚ´æ´óС£¬¿Éµ÷
alter system set sga_target=1500m scope=spfile;
--¶¨Òå³ÌÐòÇø´óÄÚ´æ´óС£¬¿Éµ÷
alter system set pga_aggregate_target=500m scope=spfile
Ïà¹ØÎĵµ£º
´æ´¢¹ý³Ì °üº¬Èý²¿·Ö£º ÉùÃ÷£¬Ö´Ðв¿·Ö£¬Òì³£¡£
¿ÉÒÔÓÐÎÞ²ÎÊý³ÌÐòºÍ´ø²ÎÊý´æ´¢¹ý³Ì¡£
Î޲γÌÐòÓï·¨
1 create or replace procedure NoParPro
2 as ;
3 begin
4&n ......
Ò»¡¢¼àÌýÆ÷(LISTENER)
¡¡¡¡¼àÌýÆ÷ÊÇOracle»ùÓÚ·þÎñÆ÷¶ËµÄÒ»ÖÖÍøÂç·þÎñ£¬Ö÷ÒªÓÃÓÚ¼àÌý¿Í»§¶ËÏòÊý¾Ý¿â·þÎñÆ÷¶ËÌá³öµÄÁ¬½ÓÇëÇó¡£¼ÈÈ»ÊÇ»ùÓÚ·þÎñÆ÷¶ËµÄ·þÎñ£¬ÄÇôËüÒ²Ö»´æÔÚÓÚÊý¾Ý¿â·þÎñÆ÷¶Ë£¬½øÐмàÌýÆ÷µÄÉèÖÃÒ²ÊÇÔÚÊý¾Ý¿â·þÎñÆ÷¶ËÍê³ÉµÄ¡£
¶þ¡¢±¾µØ·þÎñÃû(Tnsname)
¡¡¡¡Oracle¿Í»§¶ËÓë·þÎñÆ÷¶ËµÄÁ¬½ÓÊÇͨ¹ý¿Í»§¶Ë· ......
--´´½¨Óû§
create user iagent identified by ia
--profile default
default tablespace users
temporary tablespace temp;
--account unlock;
--ɾ³ýÓû§
drop user iagent cascade;
--ÐÞ¸ÄÓû§ÃÜÂë
alter user iagent identified by ia;
--¸ø´´½¨µ ......
1¡¢ÔÚ±¾»ú69ÉÏ´´½¨Êý¾Ý¿âorcl £¬global_name=orcl£¬Ê¹ÓÃÓï¾ä
alter database rename global_name to orcl.us.oracle.com ÐÞ¸ÄÊý¾Ý¿âµÄÈ«¾ÖÊý¾Ý¿âÃûΪorcl.us.oracle.com
2¡¢ÔÚÐé»ú188ÉÏ´´½¨Êý¾Ý¿âviotest£¬global_name=viotest£¬Ê¹ÓÃÓï¾ä
alter database rename global_name to viotest.us.oracle.com ÐÞ¸ÄÊý¾Ý¿âµÄÈ«¾ÖÊ ......
OracleÄÚ´æ½á¹¹ÓëʵÀý¼°Æä¹ÜÀí
1¡¢ ÄÚ´æ½á¹¹£º
OracleÊý¾Ý¿âµÄ×ÜÌå½á¹¹ÈçÏÂͼ£º
ÿ¸öOracleÊý¾Ý¿â¶¼ÊÇÓÉOracle Instance£¨ÊµÀý£©ÓëÊý¾Ý¿â£¨Êý¾ÝÎļþ£¬¿ØÖÆÎļþ¡¢ÖØ×öÈÕÖ¾Îļþ£©×é³É£¬ÆäÖÐËùνʵÀý¾ÍÊÇÓû§Í¬Êý¾Ý¿â½»»¥µÄý½é£¬Óû§Í¨¹ýÓÚÒ»¸öʵÀýÏàÁ¬À´²Ù×÷Êý¾Ý¿â¡£¶øʵÀýÓÖÊÇÓÉͳһµÄÄÚ´æ½á¹¹£¨SGA£¬PGA£¬UGA£©ºÍ ......