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 are the changes that can be made to run-time settings?

1053


How we tested remote servers if client is installed in another place

2232


What is elapsed time in load runner?

1248


I have one Scenario login then bookcoffee then logout explain test plan for above scenario?

2103


What is the difference between lr_error_message and lr_debug _message?

1080


What is x-windows?

1145


What are different types of vuser logs which can be used while scripting and execution?

1029


What is the significance of “vuser-init “?

1267


When a scenario run exactly what happened?

1097


What is transaction per second graph(pass)?

1282


What tools are required to analyze vuser run results?

1022


What is the purpose of a loadrunner transaction?

1099


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

1494


What is report header and what are the information contains?

1108


what is remote performance monitering?

2149