Re: Perl problem

From: Francois Desarmenien <desar_at_club-internet.fr>
Date: Thu, 13 Aug 1998 18:55:29 +0200
Message-ID: <35D31A81.BDFF950D@club-internet.fr>

Oracle has alway be known as CPU greedy :-)

Anyway, if you lauch your query through sqlplus directly, what is the CPU load ?

Which Perl version are you using ? I presume you're using system to launch your query, so it should make no difference...again, look at your query.

Francois

Andrea Pallotta wrote:

> HI everybody,
>
> we have a problem about an Oracle session opened by a perl script.
>
> In fact, perl script calls a sqlplus session.
>
> When we launch a long query, our oracle session has a strange
> behavior,
> 'cause it takes almost the whole cpu time to work. (97/98 %).
>
> How could we solve that problem?
>
> Our environment is Digital Unix 3.2G and Oracle 7.1.6.2 Server.
> Web server is Apache.
>
> Thanks in advance.
>
> --
> Andrea Pallotta
> Ciside_RM DataBase Practice
> -----------------------------------------------
> Digital Equipment Corporation S.p.A.
> Rome, Italy
> Andrea.Pallotta_at_Digital.com
Received on Thu Aug 13 1998 - 11:55:29 CDT