tag:blogger.com,1999:blog-4161953958134414599.post3598743360699934582..comments2023-04-19T17:04:15.831-04:00Comments on Vijay R. Dumpa Oracle Blog: Exadata Smart Scan(cell offload processing), Exadata Smart Flash Cache and Exadata Storage Index Capability'sVijay R. Dumpahttp://www.blogger.com/profile/05400068852161662003noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-4161953958134414599.post-12729605871727441272013-10-08T09:06:46.821-04:002013-10-08T09:06:46.821-04:00Good One
http://exadatacertification.blogspot.in/...Good One<br /><br />http://exadatacertification.blogspot.in/Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4161953958134414599.post-77819954021031163202012-08-22T23:45:49.536-04:002012-08-22T23:45:49.536-04:00It means that storage has send more bytes than que...It means that storage has send more bytes than query asked for .....calculation is above on asm level. Query v$sql_plan_monitor to get actual result at operation levelJignesh Kankrechahttps://www.blogger.com/profile/03655854251505412810noreply@blogger.comtag:blogger.com,1999:blog-4161953958134414599.post-90864471163838287472011-10-10T15:38:32.202-04:002011-10-10T15:38:32.202-04:00Vijay,
If the "IO_SAVED_%" is negative ...Vijay,<br /><br />If the "IO_SAVED_%" is negative (= -1492.73914930556), what does it mean?<br /><br />Best Regards,<br />EbenAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-4161953958134414599.post-48627648713753916862011-08-21T17:03:42.596-04:002011-08-21T17:03:42.596-04:00Using below SQL you should be able to pull cell of...Using below SQL you should be able to pull cell offload bytes from v$SQL view, sure. But, from the original SQL, I am getting the value (in bytes) from v$mystat view, if you rerun the original SQL again in the same session, then SQL gives cumulative bytes.<br /><br /><br />SELECT inst_id inst, sql_id,<br /> DECODE (io_cell_offload_eligible_bytes, 0, 'No', 'Yes') offloadable,<br /> io_cell_offload_eligible_bytes,<br /> DECODE (io_cell_offload_eligible_bytes,<br /> 0, 0,<br /> 100<br /> * (io_cell_offload_eligible_bytes - io_interconnect_bytes)<br /> / DECODE (io_cell_offload_eligible_bytes,<br /> 0, 1,<br /> io_cell_offload_eligible_bytes<br /> )<br /> ) "IO_SAVED_%", <br /> sql_text<br /> FROM gv$sql s<br />where sql_text like 'SELECT %'<br />ORDER BY offloadable DESC;Vijay R. Dumpahttps://www.blogger.com/profile/05400068852161662003noreply@blogger.comtag:blogger.com,1999:blog-4161953958134414599.post-33701812613002617432011-08-21T08:27:20.947-04:002011-08-21T08:27:20.947-04:00Vijay,
there are few more columns Io% in V$sql pr...Vijay,<br /><br />there are few more columns Io% in V$sql probably needs to be included to get the exact contribution of smart scan to the specific sql id. especially this query only gives cumulative bytes of the read requests since instance startup. <br /><br />-- You can use the below query to see the "cell physical IO interconnect bytes returned by smart scan" in bytes<br />SELECT a.NAME, b.VALUE<br />FROM v$sysstat a, v$mystat b<br />WHERE a.statistic# = b.statistic#<br />AND ( a.NAME IN<br />('physical read total bytes', 'physical write total bytes',<br />'cell IO uncompressed bytes')<br />OR a.NAME LIKE 'cell physical%'<br />);<br /><br /><br />--<br />Regards,<br />Nataraj.Natarajnoreply@blogger.comtag:blogger.com,1999:blog-4161953958134414599.post-35547611248657184112011-08-17T20:50:50.246-04:002011-08-17T20:50:50.246-04:00Hi Vijay,
Great article. There was some documenta...Hi Vijay,<br />Great article. There was some documentation that using the between function for date columns does not use the smart scan in exadata whereas >= and <= do. Can you confirm this?<br />Thanks.<br />Ricardo_Victorio@cox.comAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-4161953958134414599.post-743679388573378972011-08-07T15:47:29.361-04:002011-08-07T15:47:29.361-04:00Tablespace usage: You can get the details from dba...Tablespace usage: You can get the details from dba_tablespace_usage_metrics view.<br />Flash Card details: You can get the details from gv$sysstat, gv$sql and gv$active_session_history views<br /><br />All other you should be able to the pull it from AWR's.<br /><br />Cell efficiency is noting but cell node feature. (like Smart Scans, Hybrid Columnar Compression, Storage Indexes, Flash Cache etc..)<br /><br />I will post more details in my next article.Vijay R. Dumpahttps://www.blogger.com/profile/05400068852161662003noreply@blogger.comtag:blogger.com,1999:blog-4161953958134414599.post-4352833530713224382011-08-04T13:45:37.593-04:002011-08-04T13:45:37.593-04:00Hi Vijay,
I need to generate some reports/stats o...Hi Vijay,<br /><br />I need to generate some reports/stats on exadata server. reports like Tables space usage (MB)<br />Flash Card Read hits<br />Database Reads<br />Wait Events<br />Cell Efficiency<br />Grid Efficiency.<br /><br />Please help me...<br />ruthala_ramana@yahoo.comAnonymousnoreply@blogger.com