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
Cross-Instance Deadlock in RAC
-
I've created a *video demonstration of a Cross-Instance Deadlock in a
2-node RAC* environment and how to read the trace file.
Note : Only the SQL that h...
Acum 3 zile
Niciun comentariu:
Trimiteți un comentariu