UNIX SCRIPT FOR AWR [message #412393] |
Thu, 09 July 2009 02:29 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #412408 is a reply to message #412405] |
Thu, 09 July 2009 03:39 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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.
|
|
|
|
|