Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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±¾ÉíÔÚÕâ·½Ãæ¾ÍÒѾ­¿¼ÂǺÜÈ«ÁË£¬³ý·ÇÓÐЩ¸ß¼¶Ó¦Óã¬ÎÒÔÙ¿¼ÂÇ×Ô¼º´´½¨ÁÙʱ±í¡£ÓÉÓÚ±¾È˶ÔÁÙʱ±íµÄÁ˽ⲻÊǺܶ࣬ÓÚÊÇ»ØÀ´ËѼ¯ÏÂÕâ·½ÃæµÄ×ÊÁÏ£¬ÃÖ²¹ÏÂÕâ¿éµÄ²»×ã¡£
1¡¢Ç°ÑÔ
 
    ......

oracle Êý¾Ý¹ÜÀí

 Ò»£º
ʹÓÃProfile¶ÔÓû§Session»á»°½øÐÐ×ÊÔ´ÏÞÖÆ
--µ«ÊÇÈç¹ûʹÓÃÁËÁ¬½Ó³ØÖ®ÀàµÄ¶«¶«£¬¾Í»á³öЩÎÊÌ⣬±ÈÈçǰ̨Á¬½Ó²»ÉÏÖ®ÀàµÄ
--http://www.eygle.com/archives/2008/10/profile_session_limit.html
sqlplus "/ as sysdba"
SQL> show parameter resource
SQL> alter system set resource_limit= ......

¹ØÓÚORACLE ORA

 ÓÉÓÚϵͳÒÆÖ²£¬Ô­À´µÄÊý¾Ý¿â±àÂëºÍʱÇø¶¼»»ÁË£¬Ô­À´µÄһЩSQLÎÄÒ²³ö´íÁË¡£¡£
¾­³£±À³ö"ORA-01846: not a valid day of the week
"´íÎó¡£
¾­²âÊÔ£¬ÒÔÏÂÕâ¸ö¼òµ¥Óï¾äÒ²»á´í£¡£¡
SQL> select next_day(sysdate,'FRIDAY') from DUAL;
 select next_day(sysdate,'FRIDAY') from DUAL
 ORA-01 ......

¡¾ÊÕ²ØÕûÀí¡¿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ºÅ