Home » RDBMS Server » Performance Tuning » Exporting AWR data in a csv file (RHEL 6 64-bit, Oracle 12.2.0.1)
Exporting AWR data in a csv file [message #671401] Tue, 28 August 2018 19:39 Go to next message
Nagesh1985
Messages: 8
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
Re: Exporting AWR data in a csv file [message #671402 is a reply to message #671401] Tue, 28 August 2018 22:00 Go to previous messageGo to next message
BlackSwan
Messages: 26640
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?
Re: Exporting AWR data in a csv file [message #671403 is a reply to message #671402] Tue, 28 August 2018 22:07 Go to previous messageGo to next message
Nagesh1985
Messages: 8
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.
Re: Exporting AWR data in a csv file [message #671405 is a reply to message #671403] Tue, 28 August 2018 22:19 Go to previous messageGo to next message
BlackSwan
Messages: 26640
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?
Re: Exporting AWR data in a csv file [message #671406 is a reply to message #671405] Tue, 28 August 2018 22:54 Go to previous messageGo to next message
Nagesh1985
Messages: 8
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.
Re: Exporting AWR data in a csv file [message #671408 is a reply to message #671401] Wed, 29 August 2018 00:48 Go to previous messageGo to next message
Michel Cadot
Messages: 66715
Registered: March 2007
Location: Nanterre, France, http://...
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.

Re: Exporting AWR data in a csv file [message #671429 is a reply to message #671408] Wed, 29 August 2018 08:08 Go to previous messageGo to next message
BlackSwan
Messages: 26640
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/
Re: Exporting AWR data in a csv file [message #671431 is a reply to message #671403] Wed, 29 August 2018 10:41 Go to previous messageGo to next message
John Watson
Messages: 8076
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.
Re: Exporting AWR data in a csv file [message #671453 is a reply to message #671431] Thu, 30 August 2018 02:22 Go to previous message
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.
Previous Topic: Appropriate join to the desired output
Next Topic: Range Scan Index
Goto Forum:
  


Current Time: Mon Dec 09 07:56:58 CST 2019