Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How did you find database related issues?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is extended log?

1071


What are the information contain by script windows for each script in the list?

1084


What is script list?

1227


Explain the difference between automatic correlation and manual correlation?

981


What is parameterization?

1101


when i run start senario for different process it always completed at elapsed time 6.32 sec. i don't understand why it happens.. can we set elapsed time ? plz answer.... pratik196@gmail.com

2116


You want to have each step in your script measured as a transaction in the controller and not shown in the replay log in vugen. How can you accomplish this?

1045


How you develop the database vuser script?

1092


When loadrunner is used?

1046


Does caching have a negative effect on your load testing results?

1093


What type of function generate and insert by the vugen to the script when you record a script?

1169


How to record the desktop application in Loadrunner 12.53 version 64 bit window.

2148


What are the different sections of the script? In what sequence do these sections run?

1432


While the script is running we find some values that may need to be correlated? Is it possible to do manual correlation for those values?

965


How can we find database related issues?

1031