| What is the different between Oracle parse and application parse? [message #266889] |
Tue, 11 September 2007 23:06  |
trantuananh24hg
Messages: 744
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
