Hi,This is Halim,working as a Sr. Oracle DBA and PL/SQL developer in Atlanta, USA. I very much like to play with SQL, PL/SQL and scripting languages along with my DBA job. I got a recognition for PL/SQL. Please see here at 16th position(http://plsql-challenge.blogspot.com/2010/07/winners-of-first-plsql-challenge.html). I am maintaining this blog for helping myself while in work and sharing my knowledge with others. If you have any question. you can reach me at infohalimdba@gmail.com Thanks.

Sunday, March 28, 2010

why Perl.exe consume most of CPU% in oracle

when i open the oracle this perl.exe occupay all my cpu .and then my PC is going to very very very slow .plz i want know what to do now ..

Questions 2:-=====================

After starting dbconsole (emctl start dbconsole) (Latest Oracle on aWin2KSP4 box) and waiting a while two perl.exe processes come up andstart eating all the cpu and memory on the machine. I searched Metalinkand found that one possible cause may be the lack of a C: drive on thehost. This is true for me, so I mapped C: to a network drive (Metalinksuggested to install an USB drive) but the problem did not go away.

Any ideas?

Question 3 :-====================

I installed 11g 64 bit on another win2003 64 bit machine,did not patch this time. so the it's a clean plain vanilla version of 11g.Perl.exe processes are still appearing and ramping up to G of memorywhen the dbconsole is started.It seems the perl.exe process hangs on this scriptsysman/admin/scripts/lsnrresp.pl

I tested the listener and it is up and works perfectly,I can connect to the machine remotely etc.

any ideas to help me progress on this?

===========================Why run perl.exe in oracle=========================

These scripts are part of the Enterprise Manager monitoring,they are invoked by default. Dbresp.pl checks for user response time.These perl scripts are internals .

Check metalink Note:419668.1,it is one of the most common reason EM consume 100% CPUand resolution/workaround is given in above ML note.

solution:- 2===================I searched Metalinkand found that one possible cause may be the lack of a C: drive on thehost. This is true for me, so I mapped C: to a network drive (Metalinksuggested to install an USB drive) but the problem did not go away.Came to work today, installed a USB drive to get a proper C: drive (themapped one does not suffice) and it solved the problem.

solution:- 3====================Turns out the machine had no C: drive, and some perl scriptsrefer specifically to c:, had to edit a few perl files changing anyreference from c: to e:all ok now.

solution:- 4====================I have had good luck with similar problems by reducing the DB_FILE_MULTIBLOCK_READ_COUNT.Oracle used to say in its docs that MULTIBLOCK for OLTP should be between 4 and 16.

you must identified if there are other operating system proceess thatconsuming hight porcent of resources, if you enviroment is Unix, check this command