Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Manually generate AWR reports     - CentOS 7 virt-manager can not connect a local hypervisor (Linux)

- Java integrated development environment common set of operations (Linux)

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

- Debian (Wheezy) were installed wxPython GUI development (Linux)

- Linux System Getting Started Learning: Linux how to install 7zip (Linux)

- Linux performance monitoring and common commands Introduction (Linux)

- Windows environment Android Studio v1.0 Installation Guide (Linux)

- How to install or upgrade to the Linux kernel in Ubuntu 4.2 (Linux)

- Configuring Haproxy log support (syslog logging support) (Server)

- MySQL 5.6 database code changes (Database)

- NFS-based services and service utilization Corosync DRBD high availability cluster configuration, respectively (Server)

- CentOS minimal network is unavailable resolved (Linux)

- Red Hat Linux mount U disk (Linux)

- Linux operation and maintenance of the actual file system, file links (Linux)

- Redis is installed and set up Ubuntu 14.04 from the environment under the main ssdb (Server)

- SecureCRT session buffer size settings (Linux)

- Linux virtual machines to solve end MySQL database can not remote access (Database)

- GitLab installation configuration notes (Linux)

- Oracle TAF Analysis (Database)

- Oracle 11g modify MEMORY_TARGET (Database)

 
         
  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 three ways to set environment variables (Linux)
- Shuffle Process Arrangement in MapReduce (Server)
- Oracle physical storage structure outline (Database)
- Java memory area and memory overflow exception (Programming)
- To use Java arrays implement the order form (Programming)
- Linux upgrade GCC 4.8.1 clear and concise tutorials (Ubuntu 12.04 64-bit version as an example) (Linux)
- How to find on Linux and delete duplicate files: FSlint (Linux)
- Linux Apache server security (Linux)
- Linux kernel programming parameter passing between modules and function calls (Programming)
- Parts of the partition is not recognized after Debian mount mobile hard disk (Linux)
- ARM platform compiler installation Golang (Linux)
- Oracle View index and use indexes Precautions (Database)
- CentOS 7 repair MBR and GRUB (Linux)
- Editor of the popular Linux Gvim (Linux)
- How to use Evernote in the Linux command line (Linux)
- Let Mac OS X dedicated high-speed mobile hard disk can also be read in Linux (Linux)
- Linux System Getting Started Learning: the curl set custom HTTP header (Linux)
- Parse Server supports iOS and Android push messaging (Programming)
- RabbitMQ user roles and access control (Linux)
- MongoDB Learning the notes (Database)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.