Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: What's difference between "hard parse" & "soft parse"?
James Morle's book Scaling Oracel8i has the best description. He
defines 3 types of soft parses (pp279-80). Hard parse is easy.
Note that Cary Milsap doesn't like to use the phrase "soft parse":
***********begin quote****************
***********end quote****************
Yong Huang
yong321_at_yahoo.com
corvax-msk_at_yandex.ru (Corvax) 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.
Received on Mon Dec 31 2001 - 14:20:26 CST