2 Replies Latest reply: Feb 20, 2013 12:40 PM by 913089 RSS

    Smart Scans and Oracle Label Security?

    user599560
      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.-Oracle
          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
            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 ?