http://blog.ronnyegner-consulting.de/2011/10/13/info-task-blocked-for-more-than-120-seconds/
By default Linux uses up to 40% of the available memory for file system caching.
You can lower the mark for flushing the cache from 40% to 10% by setting “vm.dirty_ratio=10″ in /etc/sysctl.conf.
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