Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Adding
> > Hi all. Atm i am writing special system to store and restore
> > information. There were diffirent ideas how to do this, all have
> > pluses and minuses. Finally we desided to write system, what is
> > creating stored procedures and function by inputed architecture. Now i
> > have dilemma.
Hello Ger
I don't understand your question either and really don't recognice the
terminology, particulary that hierarchy things. I thinking on the
EXECUTE IMMEDIATE you are using.
I think that the first time the block in the EXECUTE IMMEDIATE is
used it has to be compiled and that takes some time. After that
it will be in RAM and executes mush faster. Are you by the way getting
information out from EXECUTE IMMEDIATE? If Yes, then how ?
Tables or package variables ? Stored code will certainly speed up
the time, and probably reusing the EXECUTE IMMEDIATE blocks. If your
code works today, it could be a tuning issue as someone else pointed
out.
Regards
Folke Larsson Received on Sat Feb 07 2004 - 09:47:54 CST