OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » UNIX SCRIPT FOR AWR (ORACLE 10.1.0.2.0,HP-UX)

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

UNIX SCRIPT FOR AWR [message #412393]

Thu, 09 July 2009 02:29

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

babuknb
Messages: 1736
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

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.

Report message to a moderator

Re: UNIX SCRIPT FOR AWR [message #412409 is a reply to message #412408]

Thu, 09 July 2009 03:43

babuknb
Messages: 1736
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

Report message to a moderator

Re: UNIX SCRIPT FOR AWR [message #412666 is a reply to message #412393]

Fri, 10 July 2009 07:54

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.

Report message to a moderator

Previous Topic:	ORA-07445
Next Topic:	Oracle server on internal disk vs external disk or netApp disk

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 17:26:42 CST 2024