ÔÚoracleÖÐÔö¼ÓÓû§ÏÞÖÆ
½ñÌìÔÚÏîÄ¿¿ª·¢ÖУ¬·¢ÏÖÊý¾Ý¿âÁ¬½ÓÊý¹ý¶à£¬oracleÖдæÔںܶ೬ʱÁ¬½Ó¡£µ¼ÖÂÐÂÔö¿Í»§¶ËÎÞ·¨Á¬½Óµ½Êý¾Ý¿â¡£ËùÒÔÉèÖÃÁËÇ¿ÖÆÊÍ·ÅoracleÁ¬½ÓÊôÐÔ¡£
ÔÚÍøÉϲéѯÁËÉèÖÃ˵Ã÷ÈçÏ£º
sqlplus /nolog
´ò¿ªsqlplus
connect system/bianqiwei@orcltns as sysdba
ʹÓþßÓÐdbaȨÏÞµÃÓû§µÇ½oracle
show parameter resource_limit
ÏÔʾ×ÊÔ´ÏÞ¶¨ÊÇ·ñ¿ªÆô,valueΪtrueÊÇ¿ªÆô,ΪfalseÊǹرÕ
alter system set resource_limit=true
Èç¹û먦Æô,ÔòʹÓôËÃüÁÆô×ÊÔ´ÏÞ¶¨¹¦ÄÜ
create profile profileName limit connect_time 60 idle_time 30
´´½¨profileÎļþ,profileNameÈÎÒâÆð,connect_timeÉèÖÃÁ¬½Ó³¬¹ý¶àÉÙ·ÖÖÓºóÇ¿ÖÆÊÍ·Å,idle_timeÉèÖÃÁ¬Ðø²»»î¶¯µÄ»á»°³¬¹ý¶àÉÙ·ÖÖÓºóÇ¿ÖÆÊÍ·Å
alter user oracleUser profile profileName
½«profileÎļþ×÷ÓÃÓÚÖ¸¶¨Óû§
ÔÚÊý¾Ý¿âÖеÄʵ¼Ê²Ù×÷ÈçÏ£º
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
[oracle@nsn-db-server ~]$ sqlplus "/ as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Dec 22 16:14:11 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL> show parameter resource
NAME TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
resource_limit boolean
FALSE
resource_manager_plan string
SQL> alter system set resource_limit=true;
System altered.
SQL> create profile sbaplimit20091222 limit connect_time 60 idle_time 30
&
Ïà¹ØÎĵµ£º
[ÕªÒª]Ö÷Òª´Ó´óÐÍÊý¾Ý¿âORACLE»·¾³Ëĸö²»Í¬¼¶±ðµÄµ÷Õû·ÖÎöÈëÊÖ£¬·ÖÎöORACLEµÄϵͳ½á¹¹ºÍ¹¤×÷»úÀí£¬´Ó²»Í¬·½Ãæ½ÏÈ«ÃæµØ×ܽáORACLEÊý¾Ý¿âµÄÓÅ»¯µ÷Õû·½°¸¡£
[¹Ø¼ü´Ê]ORACLEÊý¾Ý¿â¡¢»·¾³µ÷Õû¡¢ÓÅ»¯Éè¼Æ¡¢·½°¸
ÖÐͼ·ÖÀàºÅ£ºTP3 ÎÄÏ×±êʶÂ룺A ÎÄÕ±àºÅ£º1671£7597(2008)0720043£01
¡¡¡¡
¡¡¡¡ORACLEÊý¾Ý¿âÖÐÊý¾Ý´æÈ¡ÐÔÄ ......
28.6 Oracle³£¼ûÎÊÌâ´¦Àí
±¾½Ú½éÉÜÔÚRed Hat Enterprise Linux 5.2ÉÏ°²×°¼°ÅäÖÃOracleÊý¾Ý¿â·þÎñÆ÷ÖУ¬³£¼ûµÄÎÊÌâ¼°½â¾ö·½·¨£¬°üÀ¨ÈçºÎ»ñµÃÊý¾Ý¿â´´½¨¹ý³ÌÖеÄÏêϸÐÅÏ¢£¬·ÃÎÊOEM³öÏÖ“°²È«Á¬½Óʧ°Ü£¬Ê¹ÓÃÁËÎÞЧµÄ°²È«Ö¤Êé”´íÎóÒÔ¼°Íü¼ÇsysÓû§¿ÚÁîºóµÄ´¦Àí·½·¨µÈ¡£ ......
OracleÖв»ÏñÆäËûÈçmysqlµÈÊý¾Ý¿âµÄÓÐ×ÔÔö×ֶΣ¬Èç¹ûÐèÒªÔòÐèÒª½èÖúÐòÁкʹ¥·¢Æ÷
Ê×ÏȽ¨±í
½¨Á¢ÐòÁÐ
½¨´¥·¢Æ÷
For example£º
create table SYS_MESSAGE
(
ID NUMBER not null PRIMARY KEY,
M_TYPE VARCHAR2(10) not null,
TITLE VARCHAR2(200),
CONTENT LONG,
M_TIME VARCHAR2(50),
A ......
--ORACLE ÐÐתÁÐ ²âÊÔͨ¹ý£¨9i£©
/***************************************************************************************************
ÒÔѧÉú³É¼¨ÎªÀý×Ó£¬±È½ÏÐÎÏóÒ׶®
***********************************************************************************************************/
--1¡¢ÐÐתÁÐ
......