oracle 7.3.2 and oracle report 2.5: performance problem

From: univoc <univoc_at_univoc.ca>
Date: 2000/03/30
Message-ID: <W6VE4.658$A17.40454@wagner.videotron.net>#1/1

One of our client is running oracle 7.3.2 and oracle report 2.5 on one machine (AIX4.2.1, RS6000 F-50 (probably dual CPU (don't remember))). a receiving process is inserting data in 4 tables, usually 1 to 20 rows are inserted in each of the tables, tables have 2 to 7 columns each it take less then 1 seconds
Then r25runm program is called to do a postscript report on a file that will be fax after. it takes more then 30 seconds two process are running on this machine to create the faxes I run the same type of querry in max 5 seconds on single cpu half speed machine, it was working fine as far as i know for 6 month but this problem apear 2 weeks ago and now ther's some delay on the fax. :( this have run fine for 3 years on 7.2.3 and reports 2.0 on a C-10 (less then 1 seconds) (like a 286 for a RS6000)

we do a sqlplus on the database and it take 20 seconds to connect
#sqlplus

user
password
20 seconds delay
SQL>
select count(*) from yyyy (no real delay, max 70 rows on a table) ...
SQL>disconnect
SQL>quit
5 seconds
#

we do a iostats and we have no iowait 0.0 to 0.2% we have a steady 3.XX on the load average

there is a tipical ps aux of the 6 most active process

USER       PID  %CPU %MEM   SZ  RSS    TTY STAT    STIME  TIME COMMAND
fax       32916  38.9      1.0       7936   5672    -     A         14:45:44
0:07   oracleXXX (DESCRI
fax       32122  27.8      1.0       7936   5672    -     A         14:45:35
0:10   oracleXXX (DESCRI
root       516    23.9       0.0      16       20        -     A
Mar 28 1670:22 kproc
fax       20328 20.2        1.0     13588  6812    -     A         14:45:11
0:17   r25runm report=/h
root       774   17.5        0.0     16        20        -     A
Mar 28 1223:06 kproc
fax      12344  12.9        1.0     8032   5768     -     A         14:44:47

0:17 oracleXXX (DESCRI

someone have an idea of what can be the problem.

Email: jlduval_at_univoc.ca.no.spam Received on Thu Mar 30 2000 - 00:00:00 CST