buffer busy waits - enqueue

[hrishy]

Hi

From what i understand from your statspack report.

global cache cr request and db file scattered read are contributing to your wait times.

I would suggest SQL tuning esp those that are on this table
USERENTITY

Top sql's to tune would be

1)SELECT COUNT(USERENTITYID) 
  FROM USERENTITY 
  WHERE USERID = :B1

2)SELECT ENTITYPRIVILEGE.PRIVID 
FROM USERPRIVILEGES, ENTITYPRIVILEGE 
WHERE 
USERPRIVILEGES.USERENTITYID = :B1 
AND 
USERPRIVILEGES.PRIVID = ENTITYPRIVILEGE.PRIVID

3)SELECT A.USERENTITYID, A.USERID, A.FIRSTNAME, 
A.LASTNAME, A.EMAIL, A.ISDELETED, 
B.DESIGNATION, B.ENTITYID, 
B.PARENTID, B.ISUSERACTIVE, B.ISADMIN 
FROM USERMAST A, USERENTITY B 
WHERE A.USERENTITYID = B.USERENTITYID 
AND LOGINID = :B2 AND PASSWORD = :B1

Hope you have set segment space management for the BIDRXDV1 tablespace to auto.

                     bobject  Obj.      Physical
Owner    Tablespe  Obj Name     Type   Reads  	   %Total
-------- --------- ------------ -----  -----       ------
BIDRXDV1 BIDRXDV1  USERENTITY       3,782,634      99.91 91

Another object where you would expect marginal performance improvement would be RESPONSE time.

regards
Hrishy


regards
Hrishy