v$sqlarea

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 Received on Wed Aug 08 2001 - 04:52:57 CDT