[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