PERL ÒýÆðOracleÊý¾Ý¿â100% CPU
½ñÌìÓöµ½Ò»¸öÎÊÌ⣬PERL ÒýÆðOracleÊý¾Ý¿â100% CPU£¬ÏµÍ³ÊÇenterprise linux 4 update 7 64 bit
²é¿´½ø³ÌÔÀ´ÊÇgridµÄagent¡£Ö»ÓÐÏÈÍ£µôgrid
./emctl stop agent
./opmn stopall
pkill -9 perl
È»ºóÔÙ¿´¿´ÓÐûÓÐʲôbug¡£ ÕâÊǸöbug£¬ ´òÁËpatch 5908032ºóºÃÏñÕý³£ÁË¡£
oracle 549 1 99 Apr29 ? 15:51:32 /u01/app/oracle/OracleHomes/agent10g/perl/bin/perl /u01/app/oracle/OracleHomes/agent10g/sysman/admin/scripts/emdprocstats.pl 1
5727
oracle 3740 28443 0 13:56 pts/1 00:00:00 grep perl
oracle 13709 1 98 11:18 ? 02:35:18 /u01/app/oracle/OracleHomes/agent10g/perl/bin/perl /u01/app/oracle/OracleHomes/agent10g/sysman/admin/scripts/emdprocstats.pl 1
175
oracle 14667 1 98 02:22 ? 11:27:08 /u01/app/oracle/OracleHomes/agent10g/perl/bin/perl /u01/app/oracle/OracleHomes/agent10g/sysman/admin/scripts/emdprocstats.pl 2
309
oracle 30670 1 98 06:49 ? 07:01:14 /u01/app/oracle/OracleHomes/agent10g/perl/bin/perl /u01/app/oracle/OracleHomes/agent10g/sysman/admin/scripts/emdprocstats.pl 1
7612
[
Ïà¹ØÎĵµ£º
oracleËøµÄÅŶӻúÖÆ£º
ÇëÇóËø¶¨ÐèÒªÅŶӡ£Èç¹ûij¸ö»á»°ÇëÇóÒ»¸öËø¶¨£¬µ«ÊÇÓÉÓÚÆäËû»á»°ÒѾËø¶¨ÁËÖ¸¶¨¼Ç¼»ò¶ÔÏó¶øÎÞ·¨»ñµÃËùÐèµÄËø¶¨£¬ÄÇôÕâ¸ö»á»°½«»áµÈ´ý¡£´Ëʱ£¬¿ÉÄܶà¸ö»á»°¶¼Ôڵȴý·ÃÎÊÏàͬ¼Ç¼»ò¶ÔÏó£¬ÔÚÕâÖÖÇé¿öÏ£¬ORACLE»á¸ú×ÙÕâЩ»á»°ÇëÇóËø¶¨µÄ˳Ðò¡£
Èç¹û ......
´´½¨ÁÙʱ±í¿Õ¼ä
CREATE TEMPORARY TABLESPACE test_temp
TEMPFILE ' C:\oracle\product\10.1.0\oradata\orcl\test_temp01.dbf '
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;
´´½¨Óû§±í¿Õ¼ä
CREATE TABLESPACE test_data
LOGGING
DATAFI ......
create or replace type mytype IS TABLE OF varchar2(20);
declare type1 mytype :=mytype('1','2','3','4');
i number:=1;
var_str varchar(20):='liaomin';
begin
type1.EXTEND;
type1(type1.COUNT):=var_str;
loop
dbms_output.put_line(type1(i));
i:=i+1;
exit when i=type1.count+1; ......
˵Ã÷:ÏÂÎÄÖеÄһЩ˵Ã÷ºÍʾÀý´úÂëÕª×ÔCSDN,Ë¡²»Ò»Ò»Ö¸Ã÷³ö´¦,ÔÚ´ËÒ»²¢¶ÔÏà¹Ø×÷Õß±íʾ¸Ðл!
¡¡¡¡1 Óï·¨
¡¡¡¡ÔÚOracleÖУ¬¿ÉÒÔ´´½¨ÒÔÏÂÁ½ÖÖÁÙʱ±í£º
¡¡¡¡1) »á»°ÌØÓеÄÁÙʱ±í
¡¡¡¡CREATE GLOBAL TEMPORARY ( )
¡¡¡¡ON COMMIT PRESERVE ROWS£»
¡¡¡¡2) ÊÂÎñÌØÓеÄÁÙʱ±í
¡¡¡¡CREATE GLOBAL TEMPORARY ( )
¡¡¡¡O ......
ÔÚ³õѧOracleʱ£¬Ð´ÁËÒ»¸ö´æ´¢¹ý³Ì£¬Ãû³ÆÊÇ£ºPROC_GET_BILL£¬Èý¸ö²ÎÊý£¬µÚ1£¬3ÊÇin²ÎÊý£¬µÚ2ÊÇout²ÎÊý£¬Ð´ÍêÖ®ºó£¬Ïë²âһϣ¬½á¹û·¢ÏÖÍøÉÏÓжàÖÖ·½Ê½£¨ÆäÖØÒªÊÇÏÂÃæÕâÁ½ÖÖ£¬Ö»ÊÇд·¨²»Í¬¶øÒÑ£©£¬¸Õ¿ªÊ¼°ÑÁ½ÖÖ±äÁ¿¶¨Ò巽ʽ¸ã´íÁË£¬Ò»Ö±Ö´Ðв»¹ý£¬¾ÂýÂý³¢ÊÔ£¬µÃµ½ÁËÏÂÃæÁ½ÖÖд·¨£¬Ï£ÍûÏñÎÒÕâÑù³õѧÕßÉÙ×ßÍä·£¬Ö±½Ó¸ãÇåÁ½ÖÖ· ......