| |
GeekInterview.com > Interview Questions > Oracle > Memory Management
| Print | |
Question: What are the factors causing the reparsing of SQL statements in SGA
|
| July 07, 2005 12:03:46 |
#1 |
| Satyavani |
Member Since: Visitor Total Comments: N/A |
RE: What are the factors causing the reparsing of SQL statements in SGA
|
When a SQL query is executed it follows the following steps:
1) Search the shared pool. This is to ensure that the copy of the parsed statement is available in the library cache.
2) Validate the statement
3) Validate the data source
4) Acquire locks
5) Check privileges
6) Parse the statement
7) Execute the statement
8) Fetch values from cursor.
In case the parse tree is not available in the library cache it needs to reparse the statement.
Thanks,
satyavani |
| |
Back To Question | |
