Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> AWR and ASH reports
aaa12
post Mar 29 2017, 04:11 AM
Post #1


Advanced Member
***

Group: Members
Posts: 72
Joined: 15-July 15
Member No.: 50,705



Hi,

I would like to generate AWR and ASH report by weekly basis. Can I know how to generate ?
Can I have the step by step procedure with script and output.

Because when i tried to generate AWR reports, I can get snapid but unable to enter the parameter of no.of days we required.

Please assist.

Thanks
Go to the top of the page
 
+Quote Post
burleson
post Mar 30 2017, 11:43 AM
Post #2


Advanced Member
***

Group: Members
Posts: 13,491
Joined: 26-January 04
Member No.: 13



Hi aaa,

>> Because when i tried to generate AWR reports, I can get snapid but unable to enter the parameter of no.of days we required.

See here:

http://dba-oracle.com/googlesearchsite_pro...=3508j871256j17

For ASH reports, you query dba_hist_automatic_sess_history:

http://www.dba-oracle.com/t_dba_hist_activ...ion_history.htm




--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
aaa12
post Apr 4 2017, 03:27 AM
Post #3


Advanced Member
***

Group: Members
Posts: 72
Joined: 15-July 15
Member No.: 50,705



Hi,

I got an idea and had generated AWR and ASH reports.

But from here I would like to create graphs based on snap id. For this what are the contents we have to choose and will make graph?
Pls assist.

Thank

Go to the top of the page
 
+Quote Post
burleson
post Apr 4 2017, 01:46 PM
Post #4


Advanced Member
***

Group: Members
Posts: 13,491
Joined: 26-January 04
Member No.: 13



Hi,

All you do is run an individual query against the dba_hist tables and then plot then in Excel;

http://www.dba-oracle.com/t_graph_plot_oracle_output.htm

I have lots of examples here:

http://dba-oracle.com/googlesearchsite_pro...4629j2228383j14




--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 19th August 2017 - 07:27 PM