OraFAQ Forum: Performance Tuning » Exporting AWR data in a csv file

Home » RDBMS Server » Performance Tuning » Exporting AWR data in a csv file (RHEL 6 64-bit, Oracle 12.2.0.1)

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

Exporting AWR data in a csv file [message #671401]

Tue, 28 August 2018 19:39

Nagesh1985
Messages: 10
Registered: April 2016

Junior Member

Hi,
I would like to export specific data from AWR report onto a csv file. For example, I would like to export top 5 wait events for a specific snapshot from AWR report onto a csv file. I will then use this file to plot a graph for better understanding.
Are there any sql scripts that I can use, or if you can point me in the right direction where I can develop the scripts.
Thanks

Report message to a moderator

Re: Exporting AWR data in a csv file [message #671402 is a reply to message #671401]

Tue, 28 August 2018 22:00

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Nagesh1985 wrote on Tue, 28 August 2018 17:39

Hi,
I would like to export specific data from AWR report onto a csv file. For example, I would like to export top 5 wait events for a specific snapshot from AWR report onto a csv file. I will then use this file to plot a graph for better understanding.

What is on the X-axis?
What is on the Y-axis?
So what exactly will you better understand?

Report message to a moderator

Re: Exporting AWR data in a csv file [message #671403 is a reply to message #671402]

Tue, 28 August 2018 22:07

Nagesh1985
Messages: 10
Registered: April 2016

Junior Member

X-axis will be the time period. Y-axis will be any event from AWR. For example, i would like to plot the wait event "buffer busy waits" for a period of 30 days. Or plotting how a particular sql_id fared interms of elapsed time over a period of 10 days.

Report message to a moderator

Re: Exporting AWR data in a csv file [message #671405 is a reply to message #671403]

Tue, 28 August 2018 22:19

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Nagesh1985 wrote on Tue, 28 August 2018 20:07

X-axis will be the time period. Y-axis will be any event from AWR. For example, i would like to plot the wait event "buffer busy waits" for a period of 30 days. Or plotting how a particular sql_id fared interms of elapsed time over a period of 10 days.

But what if performance issue was NOT not due to wait event, but resource depletion of CPU, RAM, or I/O?
How do you know or decide why things were slow definitively?

Report message to a moderator

Re: Exporting AWR data in a csv file [message #671406 is a reply to message #671405]

Tue, 28 August 2018 22:54

Nagesh1985
Messages: 10
Registered: April 2016

Junior Member

I am using the term performance only as an example. Basically, I require a script to plot various events ( CPU, IO, memory, waits, etc) against a give time period.

Report message to a moderator

Re: Exporting AWR data in a csv file [message #671408 is a reply to message #671401]

Wed, 29 August 2018 00:48

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

Senior Member
Account Moderator

Quote:

I would like to export specific data from AWR report onto a csv file.

I would like you feedback and thank people who spend time to help you.

Report message to a moderator

Re: Exporting AWR data in a csv file [message #671429 is a reply to message #671408]

Wed, 29 August 2018 08:08

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

GOOGLE is your friend, but only when you actually use it.

https://www.thatjeffsmith.com/archive/2016/05/charting-values-over-time-in-a-sql-developer-report/

Report message to a moderator

Re: Exporting AWR data in a csv file [message #671431 is a reply to message #671403]

Wed, 29 August 2018 10:41

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

Senior Member

Nagesh1985 wrote on Wed, 29 August 2018 04:07

X-axis will be the time period. Y-axis will be any event from AWR. For example, i would like to plot the wait event "buffer busy waits" for a period of 30 days. Or plotting how a particular sql_id fared interms of elapsed time over a period of 10 days.

Is this not standard functionality in Cloud Control? CC is free, you might as well use it.

Report message to a moderator

Re: Exporting AWR data in a csv file [message #671453 is a reply to message #671431]

Thu, 30 August 2018 02:22

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

John Watson wrote on Wed, 29 August 2018 16:41

Nagesh1985 wrote on Wed, 29 August 2018 04:07
X-axis will be the time period. Y-axis will be any event from AWR. For example, i would like to plot the wait event "buffer busy waits" for a period of 30 days. Or plotting how a particular sql_id fared interms of elapsed time over a period of 10 days.
Is this not standard functionality in Cloud Control? CC is free, you might as well use it.

More or less, doesn't always give quite the precision I like though.

@OP: Just dump the data out into a sql*plus spool session. DBA_HIST_* views are what you want.

Report message to a moderator

Previous Topic:	Appropriate join to the desired output
Next Topic:	Range Scan Index

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 04 02:39:11 CDT 2025