We help IT Professionals succeed at work.

Oracle performance diagnostic sample script based on wait statistics.

GoodName
GoodName asked
on
863 Views
Last Modified: 2013-12-19
Hi,

I am looking for Oracle performance diagnostic sample script based on waits statistics.

Thanks.
Comment
Watch Question

Sean StuberDatabase Developer & Administrator
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2012
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Sean StuberDatabase Developer & Administrator
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2012

Commented:
Is there a particular wait event you're interested in?  or particular response time problem you're investigating?

Author

Commented:
Hi , Sean.

Nice to hear from you again.

I need to prepare a DB performance report a.s.a.p. and applicable recommendations for one of my clients.

I would like to analyze response time of all DB events especially related to SQL.

There are several companies on the market which use wait events analysis instead of a classical stats analysis to quicker locate performance problems (botlenecks) of Oracle 9i server / DB / Application Server / Applications. But they are really costly even for corporations I am working for.

So I am trying to find some affordable alternatives to HotSos Profiler or Confio Ignite or to write the scripts which might use the same principles and methods.

Thanks,

Sean StuberDatabase Developer & Administrator
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2012
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
It seams to me that both methods have some advantages and disadvantages.

What do you prefer? Maybe you can suggest just use scripts you referred to instead?

What are the simplest, quickest and less systems resources consuming methods or ways to identify 9i server / DBs problems?

I am open to your advices.
Database Developer & Administrator
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2012
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Thank you for such good detailed guidance!
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.