Flush Shared pool and Implications in Production
Hi All,
OS :AIX 5.3
Oracle:9.2.0.6
One of our Client DBA has flushed the Shared pool while DB is Live..
I tried searching about the the implications of Flushing shared pool but in Vain.
Any suggestion or knowledge to share...
FYI..
There were huge number of updates happening but the application has proceeses just 1000 records..It commits for every employe....
Does the FLUSHING of shared pool had anything to do with the failure of processing...
FLUSHING happened during the UPDATES