buffer busy waits - enqueue
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 12

Thread: buffer busy waits - enqueue

Threaded View

  1. #11
    Join Date
    Jan 2001
    Posts
    2,828
    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

    Code:
    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.

    Code:
                         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
    Last edited by hrishy; 06-11-2005 at 06:28 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width