Home » RDBMS Server » Performance Tuning » Clarification on using awrrpti.sql script (Oracle 11.2.0.3.0 , Linux 5.7)
Clarification on using awrrpti.sql script [message #581335] Thu, 04 April 2013 12:03 Go to next message
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 #581336 is a reply to message #581335] Thu, 04 April 2013 12:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
To get the report for only one or some instances instead of globally for all.

Regards
Michel

[Updated on: Thu, 04 April 2013 12:25]

Report message to a moderator

Re: Clarification on using awrrpti.sql script [message #581350 is a reply to message #581336] Thu, 04 April 2013 23:58 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Michel,

Could you elaborate your answer.I am not getting it.

Regards,
Jack
Re: Clarification on using awrrpti.sql script [message #581354 is a reply to message #581350] Fri, 05 April 2013 00:44 Go to previous messageGo to next message
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

Re: Clarification on using awrrpti.sql script [message #581405 is a reply to message #581354] Fri, 05 April 2013 09:19 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Michel,

@@?/rdbms/admin/awrgrpti

Is there any script like that in RAC database. i am really not getting your point.

[Updated on: Fri, 05 April 2013 09:19]

Report message to a moderator

Re: Clarification on using awrrpti.sql script [message #581406 is a reply to message #581405] Fri, 05 April 2013 09:45 Go to previous message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
So just forget it. You have not to call it.
Either you call awrrpt.sql, either, for RAC, you call awrgrpt.sql.
These are the 2 official interfaces.

Regards
Michel

[Updated on: Fri, 05 April 2013 09:46]

Report message to a moderator

Previous Topic: _library_cache_advice
Next Topic: Function takingg too long
Goto Forum:
  


Current Time: Wed Dec 18 00:47:57 CST 2024