Results 1 to 1 of 1
  1. #1
    Join Date
    Sep 2002
    Location
    Toronto, Canada
    Posts
    76

    Unanswered: Oracle perl scripts increasing the load averages

    I'm a developer stuck with the DBA duties and I need help.
    A few times a day, the load average of the Linux machine onto which Oracle is installed would increase. The average load during the day would be around 1, but during the odd times, the load would increase to around 17, even though users are not running any queries against the db.

    I ran
    Code:
    top
    and got the following output:
    Code:
    11:03:34  up 13 days,  1:30,  5 users,  load average: 17.62, 9.24, 4.32
    139 processes: 137 sleeping, 2 running, 0 zombie, 0 stopped
    CPU states:  98.8% user   1.1% system   0.0% nice   0.0% iowait   0.0% idle
    Mem:   513808k av,  507296k used,    6512k free,       0k shrd,    3664k buff
                        416116k actv,   23816k in_d,   10424k in_c
    Swap: 4192956k av,  444012k used, 3748944k free                  266812k cached
    
      PID USER     PRI  NI  SIZE  RSS SHARE STAT %CPU %MEM   TIME CPU COMMAND
     1558 oracle    25   0 84516  72M   624 R    97.8 14.4  32:36   0 perl
    22278 oracle    15   0 16812  13M 13648 S     0.7  2.7   1:40   0 oracle
     2154 oracle    15   0 54236  52M 51056 D     0.7 10.3   0:00   0 oracle
    21430 oracle    15   0  2780  840   724 D     0.1  0.1   0:00   0 oracle
    11740 oracle    15   0   760  728   372 S     0.1  0.1   2:24   0 top
     2295 oracle    19   0  1228 1228   856 R     0.1  0.2   0:00   0 top
    I also ran
    Code:
    ps | grep perl
    to find out which perl scripts where running and I got
    Code:
    oracle    1558  1557 97 10:30 ?        00:32:51 /u01/app/oracle/product/10.1.0/db_1/perl/bin/perl /u01/app/oracle/product/10.1.0/db_1/sysman/admin/scripts/emdprocstats.pl
    oracle    2159  2158  0 11:00 ?        00:00:00 /u01/app/oracle/product/10.1.0/db_1/perl/bin/perl /u01/app/oracle/product/10.1.0/db_1/sysman/admin/scripts/db/db
    resp.pl
    Anyhow, what could be causing the high load at odd times? How can I control the load keeping it around the level that I want it?


    Thanks in advance
    Last edited by unicef2k; 10-20-04 at 12:45.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •