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
Top sql's to tune would be
Hope you have set segment space management for the BIDRXDV1 tablespace to auto.
WHERE USERID = :B1
FROM USERPRIVILEGES, ENTITYPRIVILEGE
USERPRIVILEGES.USERENTITYID = :B1
USERPRIVILEGES.PRIVID = ENTITYPRIVILEGE.PRIVID
3)SELECT A.USERENTITYID, A.USERID, A.FIRSTNAME,
A.LASTNAME, A.EMAIL, A.ISDELETED,
B.PARENTID, B.ISUSERACTIVE, B.ISADMIN
FROM USERMAST A, USERENTITY B
WHERE A.USERENTITYID = B.USERENTITYID
AND LOGINID = :B2 AND PASSWORD = :B1
Another object where you would expect marginal performance improvement would be RESPONSE time.
bobject Obj. Physical
Owner Tablespe Obj Name Type Reads %Total
-------- --------- ------------ ----- ----- ------
BIDRXDV1 BIDRXDV1 USERENTITY 3,782,634 99.91 91