Skip to Main Content
  • Questions
  • Database performance issue at particular times of the day

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Abdul Wahid.

Asked: August 16, 2017 - 9:44 am UTC

Last updated: August 18, 2017 - 12:48 pm UTC

Version: 10.2.0.1.0

Viewed 1000+ times

You Asked

hi

my client says that they face a consistent database slowness issue from 10 am to 1 pm daily

please advise as a DBA how should i troubleshoot this issue, find out the root cause and expedite it towards resolution

below are the details of the database -

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit

The Tuning and Diagnostics Packs are available

below are the details of the linux server -

Red Hat Enterprise Linux ES release 4 (Nahant Update 7) 64 bit

please let me know if you would require any more information on this

thanks

and Connor said...

Collect AWR snapshots at frequent intervals (say 15mins) for the time when performance is bad *and* for when performance is good.

Then generate some representative AWR reports and examine for differences, either manually, or check out the AWR diff facilities.

https://docs.oracle.com/database/121/TGDBA/compare_stats.htm#TGDBA272

In my experience, problems of the "it only happens at certain times" are typically:

1) expensive SQL's run at those certain times,
2) server load is at peak and resources are stretched,
3) both :-)

So as well as AWR, take a look at your server load - it might be max'd out.

Rating

  (2 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

link

A reader, August 17, 2017 - 5:03 am UTC

Any link on how proceed point 2) ?

More to Explore

Performance

Get all the information about database performance in the Database Performance guide.