[Deploying Sakai] How to tune this Query in Oracle

Will Humphries Will.Humphries at tufts.edu
Tue Apr 16 06:45:20 PDT 2013


I think this query is rewritten in 
https://jira.sakaiproject.org/browse/KNL-934 . You could also take a 
look at the authz caching work in 
https://jira.sakaiproject.org/browse/KNL-600 . Note that cache is broken 
out of the box in 2.8.2 and should not be turned on unless all the work 
from KNL-600 is merged.

-Will

On 4/16/13 5:33 AM, Yasir Arfat wrote:
> Did any one tune this Qurey of sakai 2.8.2 on oracle 11g
>
> select count(1) from SAKAI_REALM_RL_FN where  REALM_KEY in (select 
> REALM_KEY from SAKAI_REALM where  SAKAI_REALM.REALM_ID IN 
> (:1,:2,:3,:4,:5)) and FUNCTION_KEY in (select FUNCTION_KEY from 
> SAKAI_REALM_FUNCTION where FUNCTION_NAME = :6)  and (ROLE_KEY in 
> (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_ID 
> = :7  and REALM_KEY in (select REALM_KEY from SAKAI_REALM where 
>  SAKAI_REALM.REALM_ID IN (:8,:9,:10,:11,:12)))  or ROLE_KEY in (select 
> ROLE_KEY from SAKAI_REALM_ROLE where ROLE_NAME = '.anon') or ROLE_KEY 
> in (select ROLE_KEY from SAKAI_REALM_ROLE where ROLE_NAME = '.auth') )
> -- 
> Yasir Arfat | Software Engineer (LMS Administrator)
> http://slate.nu.edu.pk
> National University of Computer and Emerging Sciences
> A. K. Brohi Road (Near Police Line) H11/4 Islamabad
> Tel +92-(51)-111-128-128 Ext 344  Cell +92-(343)-8502276
>
>
>
> _______________________________________________
> production mailing list
> production at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/production
>
> TO UNSUBSCRIBE: send email to production-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"



More information about the production mailing list