In our enviroment, we choose the second. After cached the table, oracle will be very smart to know that it should read the table from memory instead of read from disk.
http://dbakevin.blogspot.ro/2012/02/serious-performance-issue-caused-by-11g.html
Testing the Datadog Explain Plan Visualizer with Oracle execution plans
-
Datadog recently released a free online service explain.datadoghq.com where
you can paste in your explained SQL execution plans with metrics as JSON
text a...
Acum 4 săptămâni
Niciun comentariu:
Trimiteți un comentariu