Oracle Performance Charting Tool: Awrcrt.sql

What is AWRCRT?

The full name of AWRCRT is

AUTOMATIC WORKLOAD REPOSITORYCHART

is an Oracle Performance Trend chart Reporting tool, which is a SQL script: Awrct.sql, there is only one SQL script.

AWRCRT report is a chart that shows the performance trends for Oracle databases. AWRCRT is based on data generation in Oracle Workload repository, which is the same data source as the usual awrrpt. AWRCRT is a tool developed and maintained by the Oracle ACS Division Wang Wenjie and is provided free of charge to Oracle users.

What's the difference between AWRCRT and awrrpt?

Awrrpt is a detailed performance statistic that displays a specified short period of time (typically 1 hours to several hours). such as: 2-hour interval

AWRCRT is to display a specified longer period of time (typically 3 days the days) All the Snap interval the trend of key performance indicators. such as: from October 19 to October 25

What are the advantages of AWRCRT?

When a user reports performance issues, the database administrator may omit the time period of interest when manually selecting the starting Snap ID of the start awr.

For example, a transient performance problem occurs until 9 o'clock in the evening, but the administrator thinks the average peak is before 6 o'clock in the afternoon. After the daytime AWR report was collected, no problems were found.

Through the AWRCRT, you can cover all the most recent time periods, fully understand the performance state of the database, when is the trough, when is the peak, when has a sudden problem? Once the data of the critical time is obtained through AWRCT, it is possible to analyze the performance of the AWRRPT report specifically for that period of time, from the macroscopic to the microscopic performance analysis.

AWRCRT is a lightweight, HTML5 and JavaScript-based tool that runs SQL without installation and generates HTML reports directly. In the case where EM is not installed, it is a very good lightweight tool for understanding database performance trends. Graphical presentation, very convenient to write performance reports.

What kind of indicators can awrcrt display?

As shown below, AWRCRT can now display more than 30 key database performance metrics

• CPU Utilization
• Time Model:db time DB CPU SQL EXEC time
• Active Session History
• SQL Execution Count
• Average SQL Execution Time
• Session Logic Reads
• Physical writes and reads
• User commits
• Connections
• Redo Size
• Global Cache Transformation
• Gcs/ges messages
• Global Cache Average CR time
• Global Cache Average Current Get time
• Buffer Cache hit Point
• PGA Cache hit Point
• Library hit Point
• Latch hit Point
• Latch:shared Pool
• Latch:row Cache Objects
• Latch:cache buffers Chains
• Latch:cache Buffers LRU Chain
• LATCH:GC element
• LATCH:DML Lock allocation
• Parse Count
• Hard Parse Count
• Slowest File Average Read Wait time
• Table Fetch continued row
• Dirty Buffers Inspected
• Cell physical IO bytes eligible for predicate offload
• Cell physical IO bytes saved by storage index
• Cell physical IO Interconnect bytes returned by Smart Scan
• Cell IO Uncompressed bytes
• Top 5 Wait Event
• Top 5 Wait Event Trends

ASH

The wait event, in addition to the TOP5 event for the entire interval, is a wait event that lists all snap ranges.

Awrcrt methods and techniques of use

The usage is similar to AWRRPT

Sqlplus/as SYSDBA

@awrcrt. sql

--4 a parameter

--Parameter 1 shows the number of days of the AWR snap list

--Parameter 2 start snap ID

--Parameter 3 end snap ID

--Parameter 3 input 80 (display image related)

--Parameter 4 instance ID

After 5-60 seconds, a awrcrt*html report is generated in the current directory

TIP1: Only 11.2 and later databases are supported (due to the aggregation of string functions).

TIP2: Generally choose 5-7 days of Snap to the trend, but some library startup time is too long, the statistical value is particularly large, may cause the script inside the string exceeds the maximum length, this time, can only shorten the interval, such as 5 days or shorter

TIP3 : Why can't I see the chart?

Note that there are no ora-errors after the report generation is finished. You can also report it, cat a bit of HTML, see if there is ora-, need to make sure there is no ora-error. The old version of IE support HTML5 very poor, it is recommended to use Firefox chrome Ie10 and other browsers to see the report, generated HTML reports need and crt.js in a directory to see the chart report. If you still can't see the chart, send HTML to Valen point [email protected] dot com I'll take the time to look.

Tip4:awrcrt.sql placed on the server, if the use of VI paste, pay attention to check the size of the number of rows, often the environment, copy large files to lose characters. Preferably FTP up.

TIP5: There is no intention to deal with the database to restart the point in time, you may see more strange data, pay attention to check whether the database restarted

AWRCRT's lisence statement

Permission is hereby granted by Author, free of charge, to any person abotaining a copy of this software,
To deal in the software without restriction, including without limitation the rights to use,copy or distribute.
The copy right of the Chart JavaScript belongs to its author Nick Downie (http://www.nickdownie.com/). This JS was an open source project which
is under MIT license.
Awrcrt Author: Wang Wenjie from

Oracle Advanced Customer Support

version:1.1
date:2016-07

How to get Awrcrt.sql Baidu Network disk:

Http://pan.baidu.com/s/1mhIONVy

can also send mail to Valen point [email protected] dot com

Update plan for AWRCRT

At present, AWRCRT is a spare time update, updated about every 3-5 months, if more patrol tasks, updates are more frequent. Updates will be posted on blogs and numbers.

Oracle Performance Charting Tool: Awrcrt.sql