cell smart table scan等待事件

cell smart table scan This is an Exadata wait event typically seen during full table scans that have been offloaded to the storage cells. This event replaces waits on "direct path read" in many cases. As with direct path reads, data is returned directly to the PGA rather than going through the buffer cache. When the storage cells process full table scans they can apply columns filters and perform column projection so that not all blocks are returned, only the ones that are needed. Solutions This event indicates that a full table scan is being performed. In some cases this could be faster than an index lookup, but is not a replacement for query tuning. If the query will return a small subset of the data, utilizing an index may be more efficient. Test the differences to understand any performance penalties incurred by doing a smart table scan vs. the index lookup. Also, ensure the smart table scan is being done effectively by reviewing the Cell Smart Table Scan Latency metric on the Exadata tab under Resources in Ignite. The Objects tab in Ignite will also show response time information by object. This is critical for understanding which table is causing the majority of wait times.


本文转自maclean_007 51CTO博客,原文链接:http://blog.51cto.com/maclean/1277897

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值