Home » RDBMS Server » Performance Tuning » What is the different between Oracle parse and application parse?
What is the different between Oracle parse and application parse? [message #266889] Tue, 11 September 2007 23:06 Go to next message
trantuananh24hg
Messages: 668
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Dear all!

I have not understood about 2 concepts.

Quote:

Note the difference between an application making a parse call for a SQL statement and Oracle actually parsing the statement. A parse call by the application associates a SQL statement with a private SQL area. After a statement has been associated with a private SQL area, it can be run repeatedly without your application making a parse call. A parse operation by Oracle allocates a shared SQL area for a SQL statement. Once a shared SQL area has been allocated for a statement, it can be run repeatedly without being reparsed.



http://download.oracle.com/docs/cd/B10501_01/server.920/a96524/c16sqlpl.htm#590

Why does the Oracle parsing only allocate shared SQL area? Many documents I read which does not discuss about this.

Please tell me!

Thank you!

[Updated on: Tue, 11 September 2007 23:08]

Report message to a moderator

Re: What is the different between Oracle parse and application parse? [message #266939 is a reply to message #266889] Wed, 12 September 2007 01:10 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Why does the Oracle parsing only allocate shared SQL area?

It does this but not only this. It does much more like syntax analysis, privilege checks, execution plan generation... All these require space in the SGA.

Regards
Michel
Previous Topic: Trying to tune a query.
Next Topic: DB_Cache_Hit Ratio less than 70
Goto Forum:
  


Current Time: Thu Dec 08 21:55:58 CST 2016

Total time taken to generate the page: 0.10817 seconds