OMON: analysis of one incident

Storage syncronization to mirror took too long at 11’th Apr.

Omon “physical reads” graphs indicated a clear peek of physical reads.

24 hours graph:

1

 

A few weeks graph:

 

 

2

A few weeks graph aggregated into 200 bars:

3

AWR report indicates outstanding SQL:

4The sql itself is easy to tune by forcing index only acccess (not table reads) and a better index.

 

 

Advertisements
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s