1.UYGULAMA
1.1 To create awr reports using command line.
• We need to connect OS to Oracle user.
• We need to enter spesific directory where some oracle basic scripts are avaliable “cd $ORACLE_HOME/rdbms/admin/” .
• Now time to connect sqlplus “sqlplus / as sysdba” .
• And now we need to execute awr script “@$ORACLE_HOME/rdbms/admin/awrrpt.sql” .
Specify the Report Type 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: html /// We need to choose the format of report it can be text or html.I choose html report. Type Specified: html Instances in this Workload Repository schema ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ DB Id Inst Num DB Name Instance Host ------------ -------- ------------ ------------ ------------ * 1246424386 1 ORCL orcl localhost.lo caldomain Using 1246424386 for database Id Using 1 for instance number Specify the number of days of snapshots to choose from ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Entering the number of days (n) will result in the most recent (n) days of snapshots being listed. Pressing without specifying a number lists all completed snapshots. Enter value for num_days: 7 /// We need to choose count of days which we want to create report. Listing the last 7 days of Completed Snapshots Snap Instance DB Name Snap Id Snap Started Level ------------ ------------ --------- ------------------ ----- orcl ORCL 2 11 May 2010 22:41 1 3 12 May 2010 00:00 1 4 13 May 2010 09:34 1 5 13 May 2010 11:00 1 6 13 May 2010 14:05 1 7 13 May 2010 20:30 1 8 14 May 2010 16:46 1 9 17 May 2010 10:57 1 10 17 May 2010 13:03 1 11 17 May 2010 14:01 1 Specify the Begin and End Snapshot Ids ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Enter value for begin_snap: 3 /// This is the begining time of our report. Begin Snapshot Id specified: 3 Enter value for end_snap: 11 /// This is the ending time of our report. End Snapshot Id specified: 11 Specify the Report Name ~~~~~~~~~~~~~~~~~~~~~~~ The default report file name is awrrpt_1_3_11.html. To use this name, press to continue, otherwise enter an alternative. Enter value for report_name: awrrpt_oratech.html /// name of report
• Our report is created
Leave a Reply