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Êý¾Ý×Öµä--Êý¾Ý×Öµä±í”£¬ÎÒÃÇ̸µ½ÁËÊý¾Ý×Öµä¶ÔÓÚÎÒÃÇ×÷ΪDBA¶ÔÊý¾Ý¿âά»¤µÄÖØÒªÐÔ¡£Êý¾Ý¿âµÄ¶ÔÏóÐÅÏ¢£¬±ÈÈç±í£¬Óû§£¬´æ´¢¹ý³Ì£¬º¯Êý£¬ÊÓͼ£¬Ë÷ÒýµÈµÈ£¬ÕâЩ´æÔÚÔÚÊý¾Ý¿âÀïµÄ¶ÔÏóµÄÐÅÏ¢£¬¶¼ÊÇÔÚÊý¾Ý×Öµä±íÀï½øÐÐά»¤µÄ£¬ÎÒÃÇ¿ÉÒÔ½èÓÃһЩ±È½ÏºÃµÄOracle¿ª·¢¹¤¾ß±ÈÈçPLSQL dev»òÕß ......
1¡¢ÐòÁж¨Òå
ORACLE:
CREATE SEQUENCE <sequence_name>
INCREMENT BY <integer>
&n ......
DML Error Logging in Oracle 10g
Ö÷ÒªÔÚÓÚʹÓÃDBMS_ERRLOG.create_error_log Õâ¸ö°üÀ´¸ú×Ùdml´íÎóÐÅÏ¢
SQL> CREATE TABLE source (
2 id NUMBER(10) NOT NULL,
3 code VARCHAR2(10),
4 description VARCHAR2(50),
5 CONSTRAINT source_pk PRIMARY KEY (id)
6 );
±íÒÑ´´½¨¡£
SQL> DECLARE
2 TYPE t_tab IS ......
×÷Õߣº ÈÕÆÚ£º2005-12-8 1:43:32 À´Ô´£ºInternet µã»÷£º´Î ÆÀÂÛ
¡¡¡¡±¾ÎÄÖ»ÌÖÂÛOracleÖÐ×î³£¼ûµÄË÷Òý£¬¼´ÊÇB-treeË÷Òý¡£±¾ÎÄÖÐÉæ¼°µÄÊý¾Ý¿â°æ±¾ÊÇOracle8i¡£
¡¡¡¡Ò». ²é¿´ÏµÍ³±íÖеÄÓû§Ë÷Òý
¡¡¡¡ÔÚOracleÖУ¬SYSTEM±íÊÇ°²×°Êý¾Ý¿âʱ×Ô¶¯½¨Á¢µÄ£¬Ëü°üº¬Êý¾Ý¿âµÄÈ«²¿Êý¾ ......