Please see the below scenario and let me know how oracle works here :
Scenario 1 :
===========
1. You have created a new database and created your application schema and
you are ready to connect application .
2. Connected application and application queries started to hit your
database .
3. As this is the first time queries are parsed in your database . All
queries will follow *HARD PARSING.*
*4 . My Question is do this scenarios comes under "Library Cache miss "
concept .*
*Scenario 2 :*
1. Your database is running for last one year smoothly .And most of the
application queries are in Shared pool .
2. Today due to some issue you bounced your database . So this will flush
the shared pool
3. Now again your queries started hitting the DB and HARD PARSE happened
this time and this is case of "LIBRARY CACHE MISS "
*4 . Do Oracle have any persistent area where the information of the SQLs
are stored which were present in shared pool before instance restart . *
--
*--*
*BR*
*Sumit Tyagi*
*+91-7829543355*
