Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Manually generate AWR reports     - Using a proxy method under Linux terminal (Linux)

- Linux distributed message queue RocketMQ deployment and monitoring - Dual Master (Server)

- Oracle 11g forget approach SYS and SYSTEM password (Database)

- How to improve the performance of Ruby On Rails (Linux)

- The sublime into IDE (Linux)

- Read and write files efficiently from Apache Kafka (Server)

- How open source code libraries hosted on Github (Linux)

- dd command: do hard disk IO performance test (Linux)

- Running into the site-wide HTTPS (Server)

- Fundamentals of the Java virtual machine memory management principles (Programming)

- Linux terminal program running in the background (Linux)

- Linux, see picture not resolve the problem (Linux)

- Linux simple commands (Linux)

- Linux user management (Linux)

- Linux system security settings (Linux)

- Java learning problems encountered (Programming)

- SQL Server 2012 failover looksalive check and is alive check (Database)

- Ubuntu 14.04 installed NVIDIA graphics driver (Linux)

- Linux / Unix system-level IO (Linux)

- On event processing browser compatibility notes (Programming)

 
         
  Manually generate AWR reports
     
  Add Date : 2016-05-13      
         
       
         
  Sometimes the database is installed EM, AWR can not generate graphical reports, you need to manually generate AWR reports, Oracle provides to a sql, you can manually generate AWR reports, first create a directory to generate a report, here / home / oracle / AWR

$ Mkdir AWR
$ Cd AWR
$ Pwd
/ Home / oracle / AWR

Enter sqlplus

[Oracle @ ocp ~] $ sqlplus / as sysdba
 
SQL * Plus: Release 11.2.0.1.0 Production on Wed Dec 30 02:41:04 2015
 
Copyright (c) 1982, 2009, Oracle. All rights reserved.
 
 
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Execute scripts? Representative $ ORACLE_HOME, @ represents the implementation of sql, the default report is available in two formats, html and txt, html format by default

@? / Rdbms / admin / awrrpt.sql
Current Instance
~~~~~~~~~~~~~~~~
 
  DB Id DB Name Inst Num Instance
----------- ------------ -------- ------------
 1425858850 ORCL 1 orcl
 
 
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

Choose extracted from the system reporting period, usually seven days can be set, ORACLE will report within seven days are displayed on the screen

Enter value for num_days: 7
 
Listing the last 7 days of Completed Snapshots

Enter the start and end of the snap id snap id, the report indicates the interception period

Instance DB Name Snap Id Snap Started Level
------------ ------------ --------- ----------------- - -----
orcl ORCL 81 29 Dec 2015 13:33 1
                                82 29 Dec 2015 15:00 1
 
                                83 29 Dec 2015 16:00 1
                                84 29 Dec 2015 17:00 1
                                85 29 Dec 2015 18:00 1
                                86 29 Dec 2015 19:00 1
                                87 29 Dec 2015 20:00 1
                                88 29 Dec 2015 21:00 1
                                89 29 Dec 2015 22:00 1
                                90 29 Dec 2015 23:00 1
                                91 30 Dec 2015 00:00 1
                                92 30 Dec 2015 01:00 1
                                93 30 Dec 2015 02:00 1
 
 
 
Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 83
Begin Snapshot Id specified: 83
 
Enter value for end_snap: 93
End Snapshot Id specified: 93

Specifies the report name, if not specified, direct transport, the system will generate a report names names follow the onscreen instructions

Report written to awrrpt_1_83_93.html
     
         
       
         
  More:      
 
- Linux system performance and usage activity monitoring tools -Sysstat (Linux)
- ASM required disk format process in Solaris platforms (Linux)
- Setup Qt development environment under Linux (Linux)
- Linux System Getting Started Tutorial: How to automatically set the JAVA_HOME environment variable on Linux (Linux)
- swap space is insufficient cause OOM kill MySQL Case (Database)
- Linux installation JDK1.6 rpm.bin assembly (Linux)
- Java MVC CRUD examples (Programming)
- Java-- get the reflection object information (Programming)
- Configuring Eclipse Note Templates (Linux)
- Nginx caching using the official guide (Server)
- Vi (Vim) keyboard map and its basic commands (Linux)
- Linux ln command - create a file / directory link (Linux)
- Firewall chapter of Linux server security configuration (Linux)
- Taught you how to install Ubuntu Linux (Linux)
- open V switch port mirror in OpenStack neutron (Server)
- xCAT line installation on CentOS 6.X (Linux)
- Ubuntu install Avast antivirus software (Programming)
- MongoDB relations, references, index query coverage (Database)
- nginx.conf Optimization (Server)
- Binary search is really easy as you think you do (Programming)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.