Re: Responsiveness of Server at high CPU load

Join instead :)

On Thu, 18 Dec 2003 01:17:39 +0100, Rick Denoire <100.17706_at_germanynet.de> wrote:

>Sybrand Bakker <gooiditweg_at_sybrandb.nospam.demon.nl> wrote:
>
>
>>Preferred course of action:
>>1 fix your statements
>>2 fix your statements
>>3 fix your statements
>>4 stop symptom fighting
>>if all fails ...
>>look in to using resource plans
>
>Mr. Bakker, you might be so right. I will analyze the statement more
>thoroughly. It has something like
>
>select these, those
>from this, that
>where this IN (select .... from <table with millions of rows> where
>etc.)
>
>If the subselect returns many rows, IN is a nightmare.
>
>I will let you know.
>
>But: this is not MY statement!
>
>Bye
>Rick Denoire
>

.......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes remove NSPAM to email Received on Fri Dec 19 2003 - 09:30:49 CST