Re: What's difference between "hard parse" & "soft parse"?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 28 Dec 2001 11:24:14 +0100
Message-ID: <u2oia7sorvm4f0@corp.supernews.com>

"Corvax" <corvax-msk_at_yandex.ru> wrote in message news:ef61c6ff.0112280151.7a39d73c_at_posting.google.com...
> Hi, all!
> Could anybody tell, what is the difference between "hard parse" and
> "soft parse"?
> I mean, I would like to know what Oracle performs during "hard parse"
> and what Oracle perform during "soft parse" and how much "hard parse"
> more expensive than "soft parse".
>
> I would be very grateful to you if you would point me on Chapter (or
> any other places) in Oracle documentation.
>
> Thans in advance.

http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/ a76961/apc2.htm#30176

Gotten after
http://tahiti.oracle.com/pls/tahiti/tahiti.drilldown?remark=&word=hard+parse &book=&preference=

It's all there and online!

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address

Received on Fri Dec 28 2001 - 04:24:14 CST