Re: Linux PL/SQL cartridge calls are slow!

From: XU <xux_at_informa.bio.caltech.edu>
Date: 6 Apr 1999 17:17:07 GMT
Message-ID: <7edfij$fp3@gap.cco.caltech.edu>

The OWAS available for Linux is 3.0.2. You have to do the following to boost performance:

Before starting "owsctl start wrb" and "owsctl start admin", assign the environment variable "export OWS_ORAWEB_FEEDOMX=1" (for bash) in the user's shell who is to start the wrb and the admin listener. After that, make sure the variable is exported to the env (test with "echo $OWS_ORAWEB_FEEDOMX", you should get "1"). Start wrb and admin, and do the same test again, you will see the difference. Also check the OTN (Oracle Technology Network, http://technet.oracle.com) discussion group.

Robert XU
Bioinformatics Specialist, Oracle DBA
Caltech, Pasadena, CA 91125, USA

: kmeek_at_cpi.navsea.navy.mil wrote in message
: <7ebfjt$jl3$1_at_nnrp1.dejanews.com>...
: >We installed oracle on our linux box and got everything running pretty
: easily.
: >We ported some of our pl/sql procedures that use htp.p packages to print
: web
: >pages. They run ok, but there is about a 3-5 second delay before any of
: these
: >pages is serverd up? On our sun box these things fly.
: >
: >It is slow even for a simple htp.p('Hello World'); page.
: >
: >Any suggestions?
: >
: >I have minimum number of instances set to 10 and I'm the only user right
: now.
: >
: >Kevin
: >
: >-----------== Posted via Deja News, The Discussion Network ==----------
: >http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

: Have you tried looking in the log files to see what's going on?

: Finn
Received on Tue Apr 06 1999 - 12:17:07 CDT