| |
GeekInterview.com > Interview Questions > Oracle > Memory Management
| Print | |
Question: What are the factors causing the reparsing of SQL statements in SGA
|
| August 08, 2005 09:28:21 |
#2 |
| Shrikant Pande |
Member Since: Visitor Total Comments: N/A |
RE: What are the factors causing the reparsing of SQL statements in SGA
|
| If SGA is not properly sized it caused reparse, Oracle checks data in buffer cache first if it is not found it goes to datafile. if SGA sized properly oracle will get data in buffer and reparse wil not accur |
| |
Back To Question | |
