Re: A very interesting problem - frustrating for me but a challenge for you? 9i / mod

Home -> Community -> Usenet -> c.d.o.server -> Re: A very interesting problem - frustrating for me but a challenge for you? 9i / mod_plsql .....

From: Jim Smith <jim_at_jimsmith.demon.co.uk>
Date: Thu, 10 Mar 2005 12:12:14 +0000
Message-ID: <wzrJ$fuemDMCFwmk@jimsmith.demon.co.uk>

In message <MPG.1c9a3db6778c7c3b989dbc_at_news.individual.net>, Jeremy <newspostings_at_hazelweb.co.uk> writes
>Environment:
>9iR2 / Solaris 8 / Oracle HTTP server / mod_plsql
>
>
>
>
>A strange thing... an application runs in the above environment. Every
>minute a remote server tests for the availability of the system by
>submitting a URL which will execute a standard (i.e. part of the app)
>pl/sql packaged procedure.
>
>
>Usually this proc will take an elapsed time of < 1 sec but just
>occasionally it takes *much* longer.
>

One possibility is slow log-switching or archiving. Are there any messages in the alert log referring to waiting for log switches?

-- 
Jim Smith
Because of their persistent net abuse, I ignore mail from
these domains (among others) .yahoo.com .hotmail.com .kr .cn .tw
For an explanation see <http://www.jimsmith.demon.co.uk/spam>

Received on Thu Mar 10 2005 - 06:12:14 CST