We are doing some early evaluation of the exadata feature set (we do not have a machine available for testing). Does anyone know if queries on tables protected by OLS can take advantage of smart scans?
The My Oracle Support Community which covers all support related questions about EXADATA is available under: https://communities.oracle.com/portal/server.pt/community/exadata_general/360
Have you ever visited the Community to exchange, learn, share and get answers to your support related questions?
The answer to your query is available on the My Oracle Support Community for Exadata:
If you have not used the My Oracle Support Communities before, please watch this brief (2 minute) video to help you quickly understand the benefits available to you.
FYI, Oracle is working on a minor issue where a few of the OLS predicates are not getting offloaded to the Exadata storage if the query compares sys_context attributes to a constant value (e.g 0,1 ..etc). Development plans to have this corrected by the next distributed version.
In the meantime, this means that SYS_CONTEXT is not offloaded nor are any security predicates that depend on it.