select name, value from v$sysstat where name in ('table scans (short tables)', 'table scans (long tables)', 'index fast full scans (full)', 'index fast full scans (rowid ranges)', 'index fast full scans (direct read)', 'table scans (rowid ranges)', 'table scans (cache partitions)', 'table scans (direct read)', 'table scan blocks gotten')
查看全表扫描及全索引扫描的数量
作者:czjie
出处:http://www.cnblogs.com/czjie/
本文版权归作者和博客园共有,欢迎转载,但未经作者同意必须保留此段声明,且在文章页面明显位置给出原文连接,否则保留追究法律责任的权利。