Oracle 12c, big table caching

(mgogala) In Oracle 11g, there has been annoying change which has frequently had a seriously detrimental effect to the application performance. All tables, larger than 2% of SGA, were considered big tables and were read using direct reads into PGA, instead of SGA. That has had two undesired effects

Read More - Register for Free Membership