Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ORACLE¸ÅÒªÎļþ

¼ÇµÃÒÔÇ°ÉÏOCP¿Î³ÌµÄʱºòÄǸöÀÏʦ½ÌÎÒÃÇʹÓÃPROFILEÀ´ÏÞÖÆÓû§µÄһЩ²Ù×÷£¬ÄǸöʱºò¹À¼ÆÊÇÀÏʦ͵ÀÁ°É£¬ËùÓÐʵÑ鶼ÊÇͨ¹ýOEMµÄÐÎʽÀ´²Ù×÷£¬¸ù±¾²»»áÉæ¼°µ½ÃüÁîÐС£
ƽʱÔÚѧϰORACLEµÄ¹ý³ÌÖкÃÏñÒ²ºÜÉÙÅöµ½¹ØÓÚPROFILEµÄÎÊÌ⣬½ñÌì¹äÒ»¸öÅóÓѵÄBLOGµÄʱºò·¢ÏÖÕâƪÎÄÕ£¬¾õµÃͦºÃµÄ£¬ÄÚÈݲ»¶à£¬¼ò½àÃ÷ÁË£¬ºÃ´õÒ²ËãÊǸöÃüÁîÐвÙ×÷PROFILE£¬ºÇºÇ¡£
===========================================================
profileÏà¹Ø²ÎÊýµÄµ¥Î»ÒÔ¼°²ÎÊý˵Ã÷¡££¨ÖÐÎÄ£©
OracleϵͳΪÁ˺ÏÀí·ÖÅäºÍʹÓÃϵͳµÄ×ÊÔ´Ìá³öÁ˸ÅÒªÎļþµÄ¸ÅÄî¡£Ëùν¸ÅÒªÎļþ£¬¾ÍÊÇÒ»·ÝÃèÊöÈçºÎʹÓÃϵͳµÄ×ÊÔ´(Ö÷ÒªÊÇCPU×ÊÔ´)µÄÅäÖÃÎļþ¡£½«¸ÅÒªÎļþ¸³Óèij¸öÊý¾Ý¿âÓû§£¬ÔÚÓû§Á¬½Ó²¢·ÃÎÊÊý¾Ý¿â·þÎñÆ÷ʱ£¬ÏµÍ³¾Í°´ÕÕ¸ÅÒªÎļþ¸øËû·ÖÅä×ÊÔ´¡£
ÔÚÓеÄÊéÖн«Æä·­ÒëΪÅäÖÃÎļþ£¬Æä×÷ÓðüÀ¨¡£
1¡¢¹ÜÀíÊý¾Ý¿âϵͳ×ÊÔ´¡£
ÀûÓÃProfileÀ´·ÖÅä×ÊÔ´Ï޶±ØÐë°Ñ³õʼ»¯²ÎÊýresource_limitÉèÖÃΪtrue
ALTER SYSTEM SET resource_limit=TRUE SCOPE=BOTH;
2¡¢¹ÜÀíÊý¾Ý¿â¿ÚÁî¼°ÑéÖ¤·½Ê½¡£
ĬÈϸøÓû§·ÖÅäµÄÊÇDEFAULT¸ÅÒªÎļþ£¬½«¸ÃÎļþ¸³ÓèÁËÿ¸ö´´½¨µÄÓû§¡£µ«¸ÃÎļþ¶Ô×ÊԴûÓÐÈκÎÏÞÖÆ£¬Òò´Ë¹ÜÀíÔ±³£³£ÐèÒª¸ù¾Ý×Ô¼ºÊý
¾Ý¿âϵͳµÄ»·¾³×ÔÐн¨Á¢¸ÅÒªÎļþ£¬ÏÂÃæ½éÉÜÈçºÎ´´½¨¼°¹ÜÀí¸ÅÒªÎļþ¡£
ʾÀý:
CREATE PROFILE pro_test
LIMIT CPU_PER_SESSION 1000
--cpuÿÃë»á»°Êý
ÈÎÒâÒ»¸ö»á»°ËùÏûºÄµÄCPUʱ¼äÁ¿(ʱ¼äÁ¿Îª1/100Ãë)
CPU_PER_CALL 1000
--cpuÿÃëµ÷ÓÃÊý
ÈÎÒâÒ»¸ö»á»°ÖеÄÈÎÒâÒ»¸öµ¥¶ÀÊý¾Ý¿âµ÷ÓÃËùÏûºÄµÄCPUʱ¼äÁ¿(ʱ¼äÁ¿Îª1/100Ãë)
CONNECT_TIME 30
--ÔÊÐíÁ¬½Óʱ¼ä
ÈÎÒâÒ»¸ö»á»°Á¬½Óʱ¼äÏÞ¶¨ÔÚÖ¸¶¨µÄ·ÖÖÓÊýÄÚ
IDLE_TIME DEFAULT
--ÔÊÐí¿ÕÏÐʱ¼ä
SESSIONS_PER_USER 10
--Óû§×î´ó²¢ÐлỰÊý(Ö¸¶¨Óû§µÄ»á»°ÊýÁ¿)
LOGICAL_READS_PER_SESSION 1000 --¶ÁÈ¡Êý/»á»°(µ¥Î»:¿é)
LOGICAL_READS_PER_CALL 1000 --¶ÁÈ¡Êý/µ÷ÓÃ(µ¥Î»:¿é)
PRIVATE_SGA 16K --רÓÃsga
COMPOSITE_LIMIT 1000000 --×éºÏÏÞÖÆ(µ¥Î»:µ¥Ôª)
FAILED_LOGIN_ATTEMPTS 10 --µÇ¼¼¸´Îºó
PASSWORD_LOCK_TIME 10 --Ëø¶¨Ê±¼ä(µ¥Î»:Ìì)
PASSWORD_GRACE_TIME 120 --¶àÉÙÌìºóËø¶¨
PASSWORD_LIFE_TIME 60 --¿ÚÁîÓÐЧÆÚ(µ¥Î»:Ìì)
PASSWORD_REUSE_MAX UNLIMITED --±£Áô¿ÚÁîÀúÊ·¼Ç¼:±£Áô´ÎÊý(µ¥Î»:´Î)
PASSWORD_REUSE_TIME 120 --±£Áô¿ÚÁîÀúÊ·¼Ç¼:±£Áôʱ¼ä(µ¥Î»:Ìì)
PASSWORD_VERIFY_FUNCTION DEFAULT --ÆôÓÿÚÁÔÓ


Ïà¹ØÎĵµ£º

×ß½üOracleÊý¾Ý×Öµä(¶þ)

 ÔÚÉÏƪÎÄÕÂÀï“×ß½üOracleÊý¾Ý×Öµä--Êý¾Ý×Öµä±í”£¬ÎÒÃÇ̸µ½ÁËÊý¾Ý×Öµä¶ÔÓÚÎÒÃÇ×÷ΪDBA¶ÔÊý¾Ý¿âά»¤µÄÖØÒªÐÔ¡£Êý¾Ý¿âµÄ¶ÔÏóÐÅÏ¢£¬±ÈÈç±í£¬Óû§£¬´æ´¢¹ý³Ì£¬º¯Êý£¬ÊÓͼ£¬Ë÷ÒýµÈµÈ£¬ÕâЩ´æÔÚÔÚÊý¾Ý¿âÀïµÄ¶ÔÏóµÄÐÅÏ¢£¬¶¼ÊÇÔÚÊý¾Ý×Öµä±íÀï½øÐÐά»¤µÄ£¬ÎÒÃÇ¿ÉÒÔ½èÓÃһЩ±È½ÏºÃµÄOracle¿ª·¢¹¤¾ß±ÈÈçPLSQL dev»òÕß ......

oracle ÅÅÐòÄÚ´æ

ÎÒÔÚhttp://zhidao.baidu.com/question/123262452.html?fr=msg¡¡ÌáµÄÎÊÌ⣬ÕûÀíµ½ÕâÀï¡¡·Ç³£¸Ðл zjwssg
µÄ»Ø´ð
ÅÅÐòÄÚ´æÉæ¼°µ½PGA¡£
ʲôʱºòʹÓÃ×Ô¶¯PGAÄÚ´æ¹ÜÀí£¿Ê²Ã´Ê±ºòʹÓÃÊÖ¶¯PGAÄÚ´æ¹ÜÀí£¿
  °×ÌìϵͳÕý³£ÔËÐÐʱÊʺÏʹÓÃ×Ô¶¯PGAÄÚ´æ¹ÜÀí£¬ÈÃOracle¸ù¾Ýµ±Ç°¸ºÔØ×Ô¶¯¹ÜÀí¡¢·ÖÅäPGAÄÚ´æ¡£
  Ò¹ÀïÓû§Êý ......

ORACLEÖÐin ºÍ existsÇø±ð

INºÍEXISTSÇø±ð
in ÊÇ°ÑÍâ±íºÍÄÚ±í×÷hash join£¬¶øexistsÊǶÔÍâ±í×÷loop£¬Ã¿´ÎloopÔÙ¶ÔÄÚ±í½øÐвéѯ¡£
Ò»Ö±ÒÔÀ´ÈÏΪexists±ÈinЧÂʸߵÄ˵·¨ÊDz»×¼È·µÄ¡£
Èç¹û²éѯµÄÁ½¸ö±í´óСÏ൱£¬ÄÇôÓÃinºÍexists²î±ð²»´ó¡£
Èç¹ûÁ½¸ö±íÖÐÒ»¸ö½ÏС£¬Ò»¸öÊÇ´ó±í£¬Ôò×Ó²éѯ±í´óµÄÓÃexists£¬×Ó²éѯ±íСµÄÓÃin£º
ÀýÈ磺±íA£¨Ð¡±í£©£¬±íB ......

ʹÓÃOracle·¢ËÍÓʼþ

CREATE OR REPLACE PROCEDURE sendemailtest
(mailmsg IN Varchar2)
IS    
   --using mail server to send email.
   mailconn         UTL_SMTP.connection;
   mailhost       & ......

¡¾ÊÕ²ØÕûÀí¡¿OracleÊý¾Ý¿âÌåϵ¼Ü¹¹

 Ô­Îļûhttp://blog.csdn.net/kele1121/archive/2009/10/30/4742051.aspxÓëhttp://www.itpub.net/thread-1105403-1-1.html
 Ëùν
Oracle
µÄÌåϵ¼Ü¹¹£¬ÊÇÖ¸
Oracle
Êý¾Ý¿â¹ÜÀíϵͳµÄµÄ×é³É²¿·ÖºÍÕâЩ×é³É²¿·ÖÖ®¼äµÄÏ໥¹Øϵ£¬°üÀ¨
ÄÚ´æ½á¹¹¡¢ºǫ́½ø³Ì¡¢ÎïÀíÓëÂß¼­½á¹¹µÈ¡£
Oracle
Êý¾Ý¿âµÄÌåϵºÜ¸´ÔÓ£¬¸´Ô ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ