Clarification on using awrrpti.sql script [message #581335] |
Thu, 04 April 2013 12:03 |
|
Jack14
Messages: 497 Registered: December 2011 Location: INDIA
|
Senior Member |
|
|
Hi,
When we are able to generate AWR report on all instances using awrrpt.sql in RAC instance
then what is the purpose of introducing awrrpti.sql script in RAC instances.
Could you clarify my above questions.
Thank you
|
|
|
|
|
Re: Clarification on using awrrpti.sql script [message #581354 is a reply to message #581350] |
Fri, 05 April 2013 00:44 |
|
Michel Cadot
Messages: 68728 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
I didn't know the answer before you posted it.
It took me less than one minute to open the file and get in the header:
Quote:Rem If you want to use this script in an non-interactive fashion,
Rem without executing the script through awrgrpt, then
Rem do something similar to the following:
Rem
Rem define num_days = 3;
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/awrrac1.txt
Rem define instance_numbers_or_ALL = '1,2,3'
Rem @@?/rdbms/admin/awrgrpti
Note the "instance_numbers_or_ALL" variable. Do you understand now?
This is what is meant when we say you: "activate what is between your ears" or "think a little bit before posting your question".
Anyway, I advice to NOT try to understand scripts you are not supposed to directly call.
Regards
Michel
[Updated on: Fri, 05 April 2013 00:44] Report message to a moderator
|
|
|
|
|