This content has been marked as final. Show 4 replies
If you want to simulate Exadata on you non-Exadata test machine you can:
- set cell_offload_plan_display=always in order to se the exadata execution plan
- set _rdbms_internal_fplib_enabled (warning - undocumented - don't do it in production) which simulates some smartscan features, then you can check the cell simulated physical IO bytes eligible for predicate offload and cell simulated physical IO bytes returned by predicate offload wait events
- use Sun ZFS Storage Appliance Simulator to simulate HCC. VM available here.