[Deploying Sakai] How to tune this Query in Oracle

Yasir Arfat yasir.arfat at nu.edu.pk
Tue Apr 16 02:33:39 PDT 2013


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/production/attachments/20130416/8dd117f2/attachment.html 


More information about the production mailing list