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.

Report message to a moderator

- 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?

Report message to a moderator

- 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.

Report message to a moderator

Previous Topic: Bulk Exception giving incomplete Information.
Next Topic: STATSPACK
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 01 12:46:39 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.