From: Marcin Buchwald <Marcin.Buchwald@agora.pl>
Newsgroups: comp.databases.oracle.server
Subject: v$sqlarea
Date: Wed, 08 Aug 2001 11:52:57 +0200
Organization: NASK - www.nask.pl
Lines: 25
Message-ID: <3B710BF9.DCBE4A5C@agora.pl>
NNTP-Posting-Host: dev113.gazeta.pl
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-2
Content-Transfer-Encoding: 7bit
X-Trace: pippin.nask.waw.pl 997264379 24366 193.42.229.113 (8 Aug 2001 09:52:59 GMT)
X-Complaints-To: usenet@nask.pl
NNTP-Posting-Date: Wed, 8 Aug 2001 09:52:59 +0000 (UTC)
X-Mailer: Mozilla 4.75 [en] (Windows NT 5.0; U)
X-Accept-Language: en,pdf



I ' ve got some statements that reports execution
times of N and parse calls of 2*N times in v$sqlarea.

The exaple of such a statement is as follows:
select xx,nvl(to_char(adno),'brak') from
    (select distinct p.xx,p.adno from spacer_publog p, makieta m, drzewo
d
    where d.xx=m.drw_xx and m.xx=p.mak_xx and d.tytul=:tytul
        and p.kiedy>=to_date(:pocz,'DD/MM/RRRR') and
p.kiedy<=to_date(:kon,'DD/MM/RRRR')+1
     order by p.adno)
where rownum<=101

The thing is that it happens only in application.
With sqlplus I'm getting N - N statistics.

Any help will be appreciate

        Marcin.

****

using Ora 8.1.7 EE NT