What is Parsing and types of Parsing

  • Interview Candidate
  • 3
  • 1848

Showing Answers 1 - 3 of 3 Answers

taraldesai

  • Jun 23rd, 2007
 

when you execute query oracle checks for various things syntax, access and then generate optimize plan and in this stage parsing happens. when the query plan is already there in sga you get hit and that is soft parsing..else hard

1. Soft parsing
2. Hard parsing

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions