OraFAQ Forum: Performance Tuning » Data related to DB Metrics for a period

Home » RDBMS Server » Performance Tuning » Data related to DB Metrics for a period (Oracle 11.2.0.4 on Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Thu, 04 August 2016 03:11

orausern
Messages: 826
Registered: December 2005

Senior Member

Hi,

I have a question on some database related metrics that help to point out how much was the load on the database during a period that was peak period for us. Our application is heavily used in January and for this month we have the AWR reports for each hour on all nodes of the 2 node RAC production database. AWR has too much information and these are in too many of such hourly reports of 30 days but from this I have to pick a few metrics and its values during specific times that help to bring out how the DB load was during that time. Can you please suggest which metrics would be useful? I think the metrics that are in the "Load Profile" and "IO Profile" sections of the AWR are the one that I should focus on (we are not for this work looking into top sql etc. but only the load on the DB during that period). Is this a fair approach? Wil be thankful for your inputs.

OrauserN

Report message to a moderator

Thu, 04 August 2016 03:40

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

A simple thought: if some metrics couldn't be useful would they be in AWR?

Report message to a moderator

Thu, 04 August 2016 03:43

orausern
Messages: 826
Registered: December 2005

Senior Member

Ha! But I had a specific question and yours is a generic answer IMHO.

Report message to a moderator

Thu, 04 August 2016 03:46

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Sorry, I fail to see what is specific in your question.
Can you explain?

Report message to a moderator

Thu, 04 August 2016 03:48

orausern
Messages: 826
Registered: December 2005

Senior Member

Sorry I guess I did not bring that out clearly ,but it was the following specific point:
Quote:

Some database related metrics that help to point out how much was the load on the database during a period that was peak period for us.

Report message to a moderator

Thu, 04 August 2016 03:52

John Watson
Messages: 8976
Registered: January 2010
Location: Global Village

Senior Member

Quote:

how much was the load on the database during a period

I think you have answered your own question:
Quote:

I think the metrics that are in the "Load Profile" and "IO Profile" sections of the AWR

except that I wouldn't bother with the IO Profile stuff.

Report message to a moderator

Previous Topic:	Why rownum is not used in the query
Next Topic:	server session exceed

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 04 00:05:24 CDT 2025