Skip to Content
avatar image
Former Member

DB13 very slow

Dear all,

Could you analyze for our problem ? When we open transaction code DB13 in BW 3.5

It take time too long for open screen.

Thanks & regards,

Somkeit

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Aug 08, 2009 at 10:51 AM

    Somkeit

    Not enough informations!

    What is your database? What is the version of your database? I guess it is oracle 10g.

    run db13.....go to st03n ->expert mode ->last minutes load-- >transaction profile in analysis view. -Select db13-->click on single record. Check is it the Database Reponse time which is causing the problem.

    Response Time in Wait time CPU time DB req. Load + Gen Memory

    time (ms) WPs (ms) (ms) (ms) time (ms) time (ms) used (kB)

    3.785 3.780 0 300 3.556 7 4.274 -


    Oracle 10G

    50 49 0 50 15 4 4.274 -


    Oracle 9i

    Check note https://service.sap.com/sap/support/notes/618868

    Edited by: Anindya Bose on Aug 8, 2009 4:22 PM

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 09, 2009 at 12:49 AM

    Dear Bose,

    Thanks for your information. For more information. We're using with oracle database level 10.2.0.4

    We just migrate BW 3.5 from Windows to Linux.

    We have 2 server for compare. Why other server not found for this problem ? We have been update

    oracle statistic also. But it doesn't work. Could you analyze for us ?

    Thanks & regards,

    Somkeit

    Add comment
    10|10000 characters needed characters exceeded

    • Som

      did you check which is the longest part of the total response time? In our case it is Database Response. What is in your case?

      Check from st03n.

      >We have 2 server for compare. Why other server not found for this problem ?

      Sorry, I did not get this one.You mean you have dialog instance and in that you are not getting same response time for db13?

      or you are talking about different SAP system with the same version where you are not getting this problem.

      Please explain.

  • avatar image
    Former Member
    Aug 11, 2009 at 10:27 AM

    Dear Bose,

    Please see below for st03n record.

    Response time ( ms ) = 65146

    Wait time ( ms ) = 1

    CPU time ( ms ) = 170

    DB req. time ( ms ) = 65032

    Load+Gen time ( ms ) = 14

    Memory used ( kb ) = 4201

    In case of other server. I mean. We alrady have 2 server for migration from windows to linux. First server ( Sandbox ) we don't found for this problem. But second server ( DEV ) we found for this problem.

    Could you analyze for us from this information ?

    Thanks & regards,

    Somkeit

    Add comment
    10|10000 characters needed characters exceeded