Re: oracle 7.3.2 and oracle report 2.5: performance problem

I had the same problem with 7.3.x. We had to set an environment variable EPC_DISABLED=TRUE to resolve the problem. If this is still a problem and you need elaboration on this, just respond to the within a few days and I'll dig back through my files for the details.

John Gasch

univoc wrote:
>
> 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 Fri Mar 31 2000 - 00:00:00 CST