Event 'KSV master wait' indicates the process on the RDBMS side is waiting for a reply from a process on the ASM side. In 11g, the parameter cell_offload_processing is set to TRUE. Although that is a parameter is not applicable for non-Exadata databases, it caused ASM to try to deliver smart-scan results. The issue was reported in Bug 11800170 - ASM IN KSV WAIT AFTER APPLICATION OF 22.214.171.124 GRID PSU.
After applying the workaround for this issue (see Solution below), a drop of a tablespace that used to take 13 minutes took 4 seconds.
The following solutions are available for non-Exadata databases:
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10271187/viewspace-2129796/，如需转载，请注明出处，否则将追究法律责任。