topsql problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: topsql problem

  1. #1
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681

    topsql problem

    Hi,

    I recently bothered by our apps running slow while accessing a certain table
    CPCLASS. I tried to get the topsql resource users and i got the following
    information:

    SQL_TEXT DISK_READS = 2879986
    ----------
    SELECT COP_CARE_OF_CLASS_CODE, COP_CARE_SUB_CLASS,
    COP_CARE_OF_PARTICULARS, COP_PARTICULARS_DESC ,rowid
    FROM CPCLASS WHERE
    COP_CARE_OF_CLASS_CODE = :1
    AND COP_CARE_SUB_CLASS = :2 AND
    COP_CARE_OF_PARTICULARS = :3
    ORDER BY COP_CARE_OF_CLASS_CODE ASC ,
    COP_CARE_SUB_CLASS ASC,
    COP_CARE_OF_PARTICULARS ASC

    This table has only 6,000+ rows in it and all the columns that were used
    in the "WHERE" conditions are indexed. What possibly cause this very high
    reosource usage DISK_READS? I tried to simulate/run this program on
    sqlplus and it works fine.

    Any ideas pls....thanks

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    whos to say whether that number is bad, maybe that is since startup 3 months ago or something?

    Take a statspack report with 15 minute intervals during the slowest time - see what you are waiting on and hat sql comes out top then

  3. #3
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    Thanks,
    We just bounced our 7.1.3 database last night....is stastpak available in V7?

  4. #4
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    The users said sometimes the program is ok sometimes its not

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    no statspack wasnt in version7, i was still in shorts when version 7 was out.

    You need to use utlbstat / utlestat

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