What is a AWRCRT?
Is the full name of Awrcrt
AUTOMATIC WORKLOAD REPOSITORY CHART
Is an oracle performance trend chart reporting tools, it is a SQL script: awrct. SQL, only a SQL script,
Awrcrt report is to use a chart to show the performance of oracle database trend, Awrcrt is based on oracle workload data generated in the repository, which is the same data source and the commonly used awrrpt, Awrcrt is oracle ACS department development and maintenance of the bidding was fast, free for oracle users use a tool,
What's the difference between a awrcrt and awrrpt?
Awrrpt is to display the specified a shorter period of time (usually 1 hours to a few hours) detailed performance statistics, the diagram below:
2 hours intervals
Awrcrt is to display the specified a long period of time (usually 3 ~ 7 days) of all the snap interval of the trend of the key performance indicators, as follow: from October 19 to 25 October
What is the advantage of awrcrt?
When a user reporting performance issues, the database administrator at the start of a manual select starting who runs awr snap id, may ignore the notable period,
Such as short performance problems happen to 9 PM, but administrators think that the average peak before 6 PM, after collected who runs awr reports during the day, but have not found the problem,
Through awrcrt, can cover all the recent period, fully understand the performance of the database state, when it is low, what time is the peak, when sudden problem? Through awrct key time data, can be more specific on that time awrrpt analysis performance issues, from the performance of the reach from macroscopic to microcosmic analysis,
Awrcrt is a lightweight tool based on HTML and javascript, do not need to install and run the SQL generated HTML report directly, without installing Em, is a very good understanding of database performance trend of lightweight tools, graphical display, very convenient to write performance report,
What kind of indicators Awrcrt can show some?
As shown below, awrcrt can display more than 30 kinds of key database performance indicators
? CPU Utilization
? Time Model: DB Time EXEC SQL DB CPU Time
? The Active session history
? SQL execution count
? Business, SQL execution time
? The Session logic reads
? Physical writes and reads
? The User commits
? Connections
? Redo the Size
? Global cache transformation
? GCS/GES messages
? Global Cache business CR Time
? Global Cache business Current Get Time
? Buffer Cache Hit POINT
? PGA Cache Hit POINT
? The 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 the count
? Hard parse the count
? Slowest File business, Read Wait time
? The Table the fetch continued row
? Dirty buffers inspected
? The Cell physical IO bytes eligible for predicate offload
? The Cell physical IO bytes saved by storage index
? The Cell physical I/o interconnect bytes returned by smart scan
? The Cell IO uncompressed bytes
? Top 5 Wait Event
? Top 5 Wait Event trends
ASH
Wait for events, in addition to the entire range of top5 events, but also list all the snap interval wait for events,
The use of Awrcrt methods and skills
Usage and awrrpt similar
Up sqlplus/as sysdba
@ awrcrt. SQL
Four parameters
-
How many days - parameter 1 shows who runs awr snap list
, the start of the snap parameter 2 id
3 - parameters over the snap id
80-3 parameters input (display image related)
4 - parameter instance id
5 ~ 60 seconds, in the current directory to generate a AWRCRT * HTML report
Tip1: only support after 11.2 and database (thanks to make the polymerization string functions),
Tip2: generally choose the snap to the trend of 5 ~ 7 days, but some libraries start time is too long, statistical value is particularly big, may lead to the script inside the string exceeds the maximum length, this time, can shorten the interval, such as 5 days or less
Tip3: why I can't see the chart?
Note at the end of the report generation, do you have a ORA - error, can also report, cat HTML, look have ORA -, need to ensure that no error ORA -, older versions of Internet explorer support HTML 5 is very poor, suggest using firefox chrome IE 10 browser see report, the generated HTML report needs and CRT. Js on a directory to see chart report. If still can't see the chart, send HTML to valen wang @ oracle dot com I would have taken the time to read,
Tip4: awrcrt. SQL on the server, if the vi paste, pay attention to check the size of the number of lines, some environment, often lost characters, copy a large file to FTP, best
Tip5: not trying to deal with the database had to restart the point in time, may see more strange data, pay attention to check whether the database is a reboot
Awrcrt lisence statement
Permission is hereby granted by the Author, free of charge, to any person abotaining a copy of this software,
To deal in the software without restriction, o without limitation the rights to use, copy or distribute.
The copy right of Chart javascript belongs to its author Nick Downie (http://www.nickdownie.com/). This js is an open source project which
Is under MIT license.
Download here
http://pan.baidu.com/s/1nvDahK1 description
herehttp://www.cnblogs.com/wenjiewang/p/6120549.html
CodePudding user response:
And oracle emconsole have what difference