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±¾ÉíÔÚÕâ·½Ãæ¾ÍÒѾ¿¼ÂǺÜÈ«ÁË£¬³ý·ÇÓÐЩ¸ß¼¶Ó¦Óã¬ÎÒÔÙ¿¼ÂÇ×Ô¼º´´½¨ÁÙʱ±í¡£ÓÉÓÚ±¾È˶ÔÁÙʱ±íµÄÁ˽ⲻÊǺܶ࣬ÓÚÊÇ»ØÀ´ËѼ¯ÏÂÕâ·½ÃæµÄ×ÊÁÏ£¬ÃÖ²¹ÏÂÕâ¿éµÄ²»×ã¡£
1¡¢Ç°ÑÔ
......
Ò»£º
ʹÓÃ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= ......
select trim(leading | trailing | both ' ' from ' abc d ') from dual;
È¥µô×Ö·û´® ' abc d ' µÄÇ°Ãæ/ºóÃæ/Ç°ºóµÄ¿Õ¸ñ
ÀàËƺ¯Êý£ºltrim, ......
×÷Õߣº ÈÕÆÚ£º2005-12-8 1:43:32 À´Ô´£ºInternet µã»÷£º´Î ÆÀÂÛ
¡¡¡¡±¾ÎÄÖ»ÌÖÂÛOracleÖÐ×î³£¼ûµÄË÷Òý£¬¼´ÊÇB-treeË÷Òý¡£±¾ÎÄÖÐÉæ¼°µÄÊý¾Ý¿â°æ±¾ÊÇOracle8i¡£
¡¡¡¡Ò». ²é¿´ÏµÍ³±íÖеÄÓû§Ë÷Òý
¡¡¡¡ÔÚOracleÖУ¬SYSTEM±íÊÇ°²×°Êý¾Ý¿âʱ×Ô¶¯½¨Á¢µÄ£¬Ëü°üº¬Êý¾Ý¿âµÄÈ«²¿Êý¾ ......