This content has been marked as final. Show 10 replies
Please refer to that site;
Thanks for your reply...
I know how to run the report:
I just want to know if there is a way of running this script so that it doesn't prompt you for input.
From $OH/rdbms/admin/awrrpti.sql1 person found this helpful
Rem If you want to use this script in an non-interactive fashion, Rem without executing the script through awrrpt, then Rem do something similar to the following: Rem Rem define inst_num = 1; Rem define num_days = 3; Rem define inst_name = 'Instance'; Rem define db_name = 'Database'; Rem define dbid = 4; Rem define begin_snap = 10; Rem define end_snap = 11; Rem define report_type = 'text'; Rem define report_name = /tmp/swrf_report_10_11.txt Rem @@?/rdbms/admin/awrrpti
Is that possible to give begin time and end time instead of snaps.. as i like to run the report through shell and sent the output by mail..
Is that possible to give begin time and end time instead of snapsModify $OH/rdbms/admin/awrrpti.sql to meet your requirements.
Is that i can give begin_time and end_time instead of
Rem define begin_snap = 10; Rem define end_snap = 11;
To my knowledge, there is no such option since there may or may not be a snap for the time you give.
What you can do is create a wrapper around awrrpti.sql, find out the snaps for the time period that you are interested in, from AWR tables and pass those snap id's as input with following parameters.
Is that i can give begin_time and end_time instead ofSince the source code is available, you can change it anyway that you desire.
You could leave begin_snap & end_snap alone & just not define them.
The real key is to modify the actual code that references the variables,
Thanks satish will try that..
I do not andersand what I need to do in the case I want to use this script in a non interactive mode.
I must remove the Rem before the define comand?
May I copy the original awrrt.sql file before I tune the copy?
Please tell me what to do..Because at the end of this script there is a undefine variables. Must I change those?
Thanks a lot