Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: time for parse

Re: time for parse

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 07 Aug 1998 21:06:22 +0200
Message-ID: <35CB502D.3A82BEF7@sybrandb.demon.nl>


Ciao,
Is that a Bentley product you are using? Just curious, used to work for Bentley Europe until January, though not in the support group, and remember Sirti as one of the bigges Italian accounts. Anyway, there are some tricks to reduce the time you need for parsing First as to the actual parsing process
- if you are using synonyms make sure you are using private synonyms as they are verified first.
- Make sure every column in your select list has an appropiate table alias, otherwise the parser will look in all tables involved in the select so write
select e.empno, e.ename, d.deptno, d.dname from emp e, dept d
instead of
select empno, ename, deptno, dname
from emp, dept
Other causes:
- your datadictionary is fragmented
- your shared pool is too small.
If you don't have luck with the first approach, try increasing the shared pool first.

Good luck,

Sybrand Bakker
(postbus_at_sybrandb.demon.nl)

Giuseppe De Santis wrote:

> Ciao,
>
> I hope that you can understand this e-mail, i write in english not well.
>
> My problem is this:
> when i query a view the time for execute and fetch is insignificant.
> Instead, the delay for parse is too long, about 20 or more seconds. If i
> query again the view with the same statement the time for parse is 0
> seconds cause the rdbms keep im memory the cursor parsed.
> If i modify the statement obviously the time for parse is too long
> again. I could use binding for write the same statement, but MDL MDL is
> (a language like C) don't permit binding.
> I have noted that the sqlplus istruction:
> describe <my_view>
> for the same view, is too slow. Why? This instruction should not be open
> a cursor.
> Then my idea is: to keep in sga the view by:
> DBMS_SHARED_POOL.KEEP
> But i can pass to this procedure only package, trigger and cursor!
>
> Can someone write me the right way?
>
> Thank you
>
> Giuseppe De Santis
Received on Fri Aug 07 1998 - 14:06:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US