This content has been marked as final. Show 5 replies
903714 wrote:Yes you can have simulation by setting CELL_OFFLOAD_PLAN_DISPLAY to Always. By setting this parameter at session level you could see the change in explain plan, as optimizer would think exadata is available.
Dear Kuljeet Pal Singh,
Thanks for your information.
Currently the SPA is not available for evulation. Is there any document describe what kind of operation (e.g. Index range scan, full table scan) that Exadata can benefit in terms of performance?
Please be noted that oracle recommends not to use/infact analyze all your indexes in Exadata, as by doing FTS is much more efficient in Exadata. Once you have moved your application to Exadata, put you main indexes in INVISIBLE mode and check the benefits you get (It would be enormous :)).
basically full table scans, fast full index scans and fast full bitmap index scans are the only operations that benefit from smartscan... see tanel poders excellent post in this forum... Re: Best Practises on SMART scans