This discussion is archived
2 Replies Latest reply: Feb 20, 2013 10:40 AM by 913089 RSS

Smart Scans and Oracle Label Security?

user599560 Newbie
Currently Being Moderated
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?

Thanks
  • 1. Re: Smart Scans and Oracle Label Security?
    Dave M. Journeyer
    Currently Being Moderated
    Hi User599560 -

    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:
    https://communities.oracle.com/portal/server.pt?open=514&objID=224&mode=2&threadid=426876&aggregatorResults=T426876T426835T422126T424767T422172T415389T420356T416710T413441T415701&sourceCommunityId=360&sourcePortletId=268&doPagination=true&pagedAggregatorPageNo=1&returnUrl=https%3A%2F%2Fcommunities.oracle.com%2Fportal%2Fserver.pt%3Fopen%3Dspace%26name%3DCommunityPage%26id%3D37%26psname%3DOpener%26psid%3D36%26cached%3Dtrue%26in_hi_userid%3D173523%26control%3DSetCommunity%26PageID%3D0%26CommunityID%3D360%26&Portlet=All%20Community%20Discussions&PrevPage=Communities-CommunityHome

    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.
    http://bcove.me/rvjqwdn5

    At your service,

    Dave M.
  • 2. Re: Smart Scans and Oracle Label Security?
    913089 Newbie
    Currently Being Moderated
    You mentioned on your post at

    https://communities.oracle.com/portal/server.pt?open=514&objID=224&mode=2&threadid=426876&aggregatorResults=T426876T426835T422126T424767T422172T415389T420356T416710T413441T415701&sourceCommunityId=360&sourcePortletId=268&doPagination=true&pagedAggregatorPageNo=1&returnUrl=https%3A%2F%2Fcommunities.oracle.com%2Fportal%2Fserver.pt%3Fopen%3Dspace%26name%3DCommunityPage%26id%3D37%26psname%3DOpener%26psid%3D36%26cached%3Dtrue%26in_hi_userid%3D173523%26control%3DSetCommunity%26PageID%3D0%26CommunityID%3D360%26&Portlet=All%20Community%20Discussions&PrevPage=Communities-CommunityHome

    that there is a

    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.

    has that been corrected ?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points