1 person found this helpful
Sadly not. We have requested for It many times and have been told that its not available outside Oracle.
What you could do is...
If you have 11r2, then you could run SPA and create SQL tuning set. and Run
@?/rdbms/admin/tcellsim.sql which is going to simulate your workload according to Exadata cell.
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.