SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Results 1 to 5 of 5
  1. #1
    Junior Member
    Join Date
    Jul 2006
    Location
    finland
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Please help me with Database performance testing

    Hello!

    I have an application and management wants me to performance test it's database. How do I track down the testable code? I Could read it from Java-side, but if i want exactly the SQL what application executes on Oracle server, how do I capture it? I've heard about SQL_TRACE and tkprof and other tools, but I understand that these are only valid in same session. Should I add code to the application under test to set the SQL_TRACE on? or Can I set tracing outside a applications session??

  2. #2
    Senior Member
    Join Date
    Dec 2006
    Posts
    1,838
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Please help me with Database performance testing

    can you explain what is your requirement, if you need SQL,then you can get it from application code, if you need SP, then you can have it from Database.but again all these depends on what functionality you have under scope for testing.

  3. #3
    Junior Member
    Join Date
    Jul 2006
    Location
    finland
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Please help me with Database performance testing

    My requirement consists of several critical use-cases wich performance should be validated against performance requirements with different loads and volumes.

    Yes, but if I read it from application code there are some dynamic parameters wich I can't possible know without
    executing the code. I think that SQL_TRACE is somekind of tool to find out exactly the SQL executed?? There can be also some O/R- spesific code wich I cant generate by hand to SQL.

    how do I know witch user I am logged in database (that is different from application user ?)

    Should I use instance level tracing?? But the problem here is that other testers are testing functional test and i do not want to confuse tracing information with them.

    Thank you for your answer, hope this leads forward the discussion...

  4. #4
    Senior Member
    Join Date
    Dec 2006
    Posts
    1,838
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Please help me with Database performance testing

    [ QUOTE ]
    My requirement consists of several critical use-cases wich performance should be validated against performance requirements with different loads and volumes.


    [/ QUOTE ]
    i am not sure but your requirement suits more to the unit testing rather performance testing.i am assuming that you have enough experience in Performance testing.
    All your question are related to database admin side domain,based on your flavour of database,you can surely do google for them,MSSQL has sp_who Procedure,oracle has v$SESSION table etc for giving you details.
    i suugest you to point all these question to your DBA who is the best person to guide you.

    Check http://www.oreview.com/9604har.htm and it has all your answers.
    All the best.

  5. #5
    Senior Member
    Join Date
    Dec 2006
    Posts
    1,838
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Please help me with Database performance testing

    Forgot to mention in case you do not have sufficient working understanding of oracle,i would suggest you to keep away from it as you are entering the area where parameters are highly dependent on each other and any installation or changes may screw the overallapplication behaviour.
    Inform your DBA about your every step.

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Search Engine Optimisation provided by DragonByte SEO v2.0.36 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Resources saved on this page: MySQL 11.54%
vBulletin Optimisation provided by vB Optimise v2.6.4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.2.8 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominate (Lite) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 06:14 AM.

Copyright BetaSoft Inc.