How did you find database related issues?

Answers were Sorted based on User's Feedback



How did you find database related issues?..

Answer / dinesh gawande

If you are using Oracle as database: Oracle comes with a
utility called 'Statspack'. Using statspack you can
identify time/cpu consuming queries, no of hard parses,
queries causing bottlenecks, sequential reads,wait events,
buffer pool advisory, IO statistics and many more things.

When ther is load on the database, generate some statspack
reports and then analyse them. You will get to know/solve
most of the oracle db related issues from statspack report.

Is This Answer Correct ?    7 Yes 0 No

How did you find database related issues?..

Answer / anaz

By Using Database Monitors and DB Resource graph will give
the information for DB

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More Load Runner Interview Questions

Hi I want to learn Performance testing using load runner..Can anyone suggest me which is the best institute for load runner in bangalore??

6 Answers  


how do u analyze result & what r analze results in load runner?

2 Answers  


why do u need a parameterize fields in ur virtual user script ?

5 Answers  


What is memory leakage?

3 Answers   Fiserv,


I have generated a script and inserted the rendezous point in that. With the help of dev. we have a created script which tracks the execution of the request and the response on the server machine and shows on the cmd console. I have assigned 10 Vusers and started the execution, then while tracking on the server machine, the requests are assigned one by one on the server. According to the rendezous point, the requests has to hit at a time on the server, but in this case the request are hitting one by one on the server. Any one help me out......

1 Answers  






What is the difference between overlay graph and correlate graph?

0 Answers  


How many values can be generating in script we can Parameterize even it is in one scenario 1000Parameterization values are there it is correct to Parameterized?or not?

1 Answers   Accenture,


What is parameterization?

0 Answers  


What are the main Performance issues in JBoss server? And How to do it?

1 Answers  


)What r pre settings while recording a script?

2 Answers   EDS,


i have 4 systems 1-windows,1-unix,1-linux,1-solaris. 100 vusers to 25 vusers each system. script was created in windows system. then i want to know how can i do this, do i need to install LR in all the systems ? please explain whole the scenario up to...Run step by step---plz give answer only realtime...?

5 Answers   HP,


In what situation would u want to parameterize a text verification check ?

4 Answers  


Categories