Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

awrrpti.sql

The awrrpti.sql script in located in the $ORACLE_HOME/rdbms/admin directory. 
The awrrpti.sql SQL script generates a report (in HTML or text) that displays statistics for a range of snapshot Ids on a specified instance.
The only difference between awrrpt.sql and awrrpti.sql is that awrrpti.sql reports on a single instance.
awrrpti.sql

As discussed earlier, the awrrpt.sql script will generate an AWR report for the current instance. If you want to generate a report for another instance, the awrrpti.sql script can be used instead. The script will ask for the database ID and the instance ID.
SQL> @?/rdbms/admin/awrrpti.sql
 
Specify the Report Type
~~~~~~~~~~~~~~~~~~~~~~~
Would you like an HTML report, or a plain text report?
Enter 'html' for an HTML report, or 'text' for plain text
Defaults to 'html'
Enter value for report_type: text
 
Type Specified:  text
 
 
Instances in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
 
       DB Id Inst Num DB Name      Instance     Host
------------ -------- ------------ ------------ ------------
  2793090278        2 ORCL         orcl2        host02
* 2793090278        1 ORCL         orcl1        host01
 
Enter value for dbid: 2793090278
Using 2793090278 for database Id
Enter value for inst_num: 2
Using 2 for instance number

The asterisk shows the currently connected instance. You can choose to run the report for any of the instances of the database. At this point, the rest of the AWR report is no different than the awrrpt.sql script as discussed in the previous section of this chapter.  

Comments

Popular posts from this blog

Oracle DBMS SCHEDULER Examples

How to find the server is whether standby (slave) or primary(master) in Postgresql replication ?

7 Steps to configure BDR replication in postgresql

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

How to Enable/Disable autovacuum on PostgreSQL