Home » RDBMS Server » Performance Tuning » Statspack Report
Statspack Report [message #114906] Wed, 06 April 2005 05:43 Go to next message
milind_sri
Messages: 70
Registered: February 2005
Location: Pune
Member

Hello Experts,

I am facing problems with my DB. The performance is very poor and always hangs. I generated the Statspack report which i am attaching for your reference. I am new to performance tuning and cant understand how to identify the bottlenecks of the database through the statspack report.
Can anybody help me regarding this and tell me what are the standards which I should concentrate on to improve performance.

And, also can anybody give me some tips to read the statspack report like which events to concentrate on and other things.

Pls. reply as soon as possible.

Thanks in advance.

Milind.
Re: Statspack Report [message #115464 is a reply to message #114906] Mon, 11 April 2005 16:47 Go to previous messageGo to next message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
Have you read the chapter in the oracle documentation on statspack?
Re: Statspack Report [message #115565 is a reply to message #115464] Tue, 12 April 2005 12:32 Go to previous message
pscjhe
Messages: 38
Registered: April 2005
Member
I don't see any major problem with your instance.
Load is low 0.11 tranx/sec. Instance efficiency is good. wait event are mostly idle, waiting for client.

I think mid-tier application or web.
aspnet_wp.exe should be checked.
Previous Topic: Bulk Exception giving incomplete Information.
Next Topic: STATSPACK
Goto Forum:
  


Current Time: Sat Sep 19 01:48:31 CDT 2020