Home » RDBMS Server » Server Administration » UNIX SCRIPT FOR AWR (ORACLE 10.1.0.2.0,HP-UX)
UNIX SCRIPT FOR AWR [message #412393] Thu, 09 July 2009 02:29 Go to next message
vinniora
Messages: 56
Registered: October 2008
Location: Mumbai
Member
Hello to all,i would like to know that is there any unix shell script for automatic generation of awr report so that it can call any procedure(related to awr),as i know that i can call awrrpt.sql script but it will ask for snapshot id,is there any way that snapshot id will be taken by the report automatically i mean to say the whole process become automatic.
please help me out.Thnx in advance

[Updated on: Thu, 09 July 2009 02:35]

Report message to a moderator

Re: UNIX SCRIPT FOR AWR [message #412405 is a reply to message #412393] Thu, 09 July 2009 03:26 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

What's about stats$snapshot dynamic performance view?

select name,snap_id,to_char(snap_time,'DD.MM.YYYY:HH24:MI:SS')
     "Date/Time" from stats$snapshot,v$database;

Babu

[Updated on: Thu, 09 July 2009 03:27]

Report message to a moderator

Re: UNIX SCRIPT FOR AWR [message #412408 is a reply to message #412405] Thu, 09 July 2009 03:39 Go to previous messageGo to next message
vinniora
Messages: 56
Registered: October 2008
Location: Mumbai
Member
>>select name,snap_id,to_char(snap_time,'DD.MM.YYYY:HH24:MI:SS')
"Date/Time" from stats$snapshot,v$database;

how this query will help me out as awrpt ask for the snapshot id to be a an input.
Re: UNIX SCRIPT FOR AWR [message #412409 is a reply to message #412408] Thu, 09 July 2009 03:43 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


>>how this query will help me out as awrpt ask for the snapshot id to be a an input.

>>is there any way that snapshot id will be taken by the report automatically i mean

You need to write Unix-PL/SQL custom script to select begin snap id and end snap id using the above SQL query.

ASAIK it's possible to automate AWR report generation.

Thanks

Re: UNIX SCRIPT FOR AWR [message #412666 is a reply to message #412393] Fri, 10 July 2009 07:54 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Ask your unix admin to do so.

If you have none, you would either create script by yourself or hire an unix expert and let him to do.
Previous Topic: ORA-07445
Next Topic: Oracle server on internal disk vs external disk or netApp disk
Goto Forum:
  


Current Time: Sat Dec 03 22:04:32 CST 2016

Total time taken to generate the page: 0.04930 seconds