츩ʿµǰ

HOME

ENGLISH


English

Oracle awr report in depth analysis

3 Automatic Workload Repository (AWR) – Built-in repository of performance information ( Light Weight) – Snapshots of database metrics taken every 60 minutes and retained for 7 days – Foundation for all self-management functions – Data to find root cause and suggest remedies. An example from my test instance is shown below. Introduction. Rated as Best Oracle Golden Gate Training Institute in India. • List of all unique SQL statements with one-line performance summary per statement. Why is there a discrepancy between the Top SQL report in Performance Analysis and the Oracle awr reports? PA shows a query executed ~8000 times, while looking at approximately the same window (even less) with awr reports, the actual # of executions is ~47000 times. 1TABLE OF CONTENTS. 2. Troubleshoot problems in areas such as extraction, replication, missed transactions, mapping, synchronization,The optimizer will work in the new tuning mode wherein it conducts an in-depth analysis to come up with a set of recommendations, the rationale for them and the expected benefit if you follow the recommendations. on a day when performance was poor. view and analyze AWR and ASH data. House of Brick consultants assess Tier 1 Oracle workloads using a number of load generating tools and performance reports. Performance Tuning Basics 15 : AWR Report Analysis. Oracle Performance Diagnostic Guide Slow Database Version 3. I've gathered 32 AWR reports at 15 mins interval, from these 32 reports, have extracted 5 top intervals, my criteria for making an interval candidate for performance tuning is because of DB Time, the max DB time is top interval. Active Session History (ASH) you can produce the ASH/AWR Report which is very similar to the STATSPACK Report. there is no reason to show cumulative values in a Statspack / AWR report. Automatic Workload Repository (AWR), a licensed feature of Oracle, is one of the best tools to monitor the performance …There are several ways to produce reports from the ADDM analysis which will be explained later, but all follow the same format. Let me create a test case : I will take different OS statistics and run time statistics to compare with AWR report generated after execution. There are many YouTube videos available. By going through the AWR Report we can easily solve issues like slow database, high wait events, slow query and many more issues. Time Model Statistics 5. pdfManaging Oracle Database 12c with Oracle Enterprise Manager 12c Martin Pena Senior Director, Product ManagementSome performance issues are literally impossible to solve using an AWR Report or Oracle's time model. -Implement ASMM. In this post we will try to understand the AWR report itself. I'm having a database AWR report with me. Dear Team, Please share some bokks details for AWR and ASH report analysis in depth. Here in this example, the Elapsed Time is around 60 minutes while the DB Time is around 700 minutes. SYSAUX. By Reading AWR Report you can easily solve issues like Slow …If you are a beginner, you can also use Ion for Oracle to automate the generation of AWR deltas, in a more readable report format, with additional tips. 08. Oracle database performance tunning is very complex task, you should know in depth knowledge of Oracle database architecture like internal structure of shared pool, Database buffer cache, redo log buffer cache, wait class and wait events, statistics, histogram, analyse AWR report, ASH report and various database tunning utilities knowledge etc. The second section of the report header contains load The report header provides information about the instance upon which this report was run. It does not tell you whether any problems did or did not occur, or what those problems might be. This short guide provides a crash course into how to quickly analyze AWR reports to identify performance issues, as well as possible infrastructure solutions that can help ensure that those problems are eliminated for good. (2 replies) Hello all - I'm composing a few historical reports from the AWR, using this link as a guide: http://www. ADDM tries to report the most significant performance problems during an analysis period in terms of their impact on DB time. -Commit more records at a time. Of course, the AWR report cannot include an instance restart. Where to find DB time in AWR report? There are two places where you can find the DB Time in AWR report. 2 or above The issue came to light when investigating a report performance issue on an Oracle 11. Oracle Database Tips by Donald BurlesonMay 16, 2015 Report Summary: This gives an overall summary of the instance during the snapshot period, Wait Events: This AWR report section provides more detailed wait event information for 16. 4 non-RAC database. com/presentation/336697426/Training-PPTIndia Overview of the AWR Report Understanding Response Time • Database response time is the time the RDBMS took to satisfy a request • Response Time = CPU time + Wait time • Oracle keeps track of these metrics for all sessions • AWR snapshots capture total CPU and wait times at a certain point in time • An AWR report will obtain the difference of the snapshot data • An AWR report Search among more than 1. The report can be generated as of Oracle 10. Automated Change Tracking – Identifies and sends notifications of changes to server, instance, database, schema …In this article we walk you through how to run, compare and read an Oracle AWR report. The value shown will be all server process CPU consumption within the reporting snapshot interval, converted to seconds. 7 Resolving Transient Performance Problems Transient performance problems are short-lived and do not appear in the Automatic Database Diagnostics Monitor (ADDM) analysis. awrgrpt. Performance Insight 가 Aurora for PostgreSQL(나머지 DBMS 는 2018년 내) 에 런칭 되었으며 In-depth Analysis 부분의 DB Monitoring 기능을 제공, 꾸준히 Upgrade 될 것으로 보입니다. Lets start from the beginning of an typical AWR that i got from one of test databases : Here one can check interval report has been made for, database name, etc. sql - Produces the AWR report for a specified database and instance . Note: • The term INCIDENT referred in the following parts… Life DBA. sql and the ASH report is named ashrpt. Hi Forstmann, Thanks for the links. These AWR data are available in about 80 "tables" whose names begin with " DBA_HIST ". Both link will definitely help you to understand report. Understanding AWR Report June 13, 2012 Posted by Mich Talebzadeh in Oracle. I searched in google, but cant find any documents on it. Oracle. Performance tools can examine execution strategies and can be used for SQL tuning, the tools can give you a good estimate of resource usage used by the queries. m. Investigating the original report problem required an AWR analysis and a SQL trace (actually a 10046 level 12 trace – tracing the bind variables was of critical importance in troubleshooting the initial problem with the report). § The database ID is 37933856. Real Time – AWR Report Analysis - Real Time – AWR Report Analysis - Oracle DBA Performance Tuning - Software Functionality, OS Dependencies, Application and Networking Architecture, Memory Dependancies, Performance Tuning Tools, Tracing SQL execution, Oracle Enterprise Manager, SQL Tuning Advisor & Baselines, Histograms and Bind Peeking spAnalyzer is a tool which provides analysis of text report files generated by Oracle Automatic Workload Repository (AWR) and STATSPACK tools. 5. awrrpt. 05. There are so many reasons why Oracle does not share the same statement. The AWR automatically collects and stores statistical data in the sysaux tablespace. This collective information can be displayed as views and reports (HTML/text) to better show the current database performance status for further analysis. The goal of ADDM analysis is to reduce a single throughput metric called DB time. The first Oracle mentoring service in Poland – its target group include administrators, developers and IT managers. The resulting report can be opened in a browser or text editor. Because performance management tools are a must-have for all DBA, you can use Oracle Enterprise Edition with Lighty and AWR metrics, but also with the Standard Edition, Edition One or Standard Edition Two. Let me create a test case : I will take different OS statistics and run time statistics to compare with AWR report generated after execution. It is covered by Oracle's Diagnostic Pack License . Makes specific performance recommendations. AWR SQL_ID specific report is named awrsqrpt. The following script is used with Oracle databases for generating multiple AWR reports between two points in time (determined by snapshots in the Automatic Workload Repository – one report per snapshot). spAnalyzer produces HTML report that contains performance tuning tips and hints which are based on performance data containing in AWR or STATSPACK text report. Aufrufe: 363Videolänge: 10 Min. Messina, Management Consultant Rolta-TUSC, Oracle Open World 2009 (30 min). 0 January 13, 2009 Welcome to the Oracle Performance Diagnostic Guide This guide is intended to help you resolve query tuning, hang/locking, and slow database issues. to midnight on a day when performance was good and from 10:00 a. • Automatic Workload Repository (AWR) •Is the Oracle performance warehouse •AWR allows the collection and analysis of performance data •Offers more Information than statspack •Enterprise Manager - Cloud Control •Graphical web-based console which provides a single, integrated solution for administration, Collecting Oracle stats is often required to diagnose performance problems associated with running Oracle database applications on NetApp filers. 3 Top 5 Timed Foreground Events 4. Oracle AWR report Analysis Table of contents. In my previous article, titled, “An Oracle Instructor’s Guide to Oracle 10g,” I presented a high-level overview of some of the new features in Oracle’s latest release. sql if you’re interested in running them from the command line via SQLPlus instead of using EM12c. The data in an AWR report is the delta, or changes, between the accumulated metrics within each snapshot. sql Displays various statistics for a range of snapshots Ids. Table of contents 2. com/technology/products/manageability Oracle AWR Report AWR is Oracle’s mechanism for gathering and preserving statistics useful for performance analysis. Latch statistics in AWR report contain following sections. This regional collaboration targets both 온-프레미스 환경에서의 모니터링은 크게 임계치 설정 등 에 따른 경고 메시지를 SMS 등으로 수신하는 Alert Notify 기능과 성능지표 등을 한 눈에 모니터링 하기 위한 Dash Board 기능, Trouble Shooting 등에 필요한 Back Data 수집 및 분석을 위한 In-Depth Analysis 기능 3가지 This Oracle GoldenGate 12c Troubleshooting and Tuning training teaches you how to gather and examine evidence; you’ll also learn to solve case problems, diagnose their cause and find methods of …By enrolling in this course, you'll develop deeper knowledge of Oracle GoldenGate 12c performance tuning methods. A Texas Memory Systems Presentation AWR Report Header WORKLOAD REPOSITORY report for Introduced in Oracle 10g and having evolved from the Statspack functionality of Oracle 8i/9i, the Automatic Workload Repository report or AWR report (as it is more commonly known as) is a vital The Oracle’s Automatic Workload Repository (AWR) collects, processes, and maintains performance statistics for problem detection and self-tuning purposes. At The Start of AWR Report. “Always on” approach to performance metrics with requirement of non-locking collection process. Interval in this report is 8 hours, it is quite large but for particular system is very useful. Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. If we have Once AWR Report is generated in Oracle, the next task is to analyze it. Aug. This functionality requires Enterprise Edition and the Diagnostics and Tuning option. The AWR header was expanded to include data about the platform, CPUs, cores, and sockets, as well as memory available in the server. spAnalyzer is a tool which provides analysis of text report files generated by Oracle Automatic Workload Repository (AWR) and STATSPACK tools. Reading and understanding AWR reports. Real Time – AWR Report Analysis - Real Time – AWR Report Analysis - Oracle DBA Performance Tuning - Software Functionality, OS Dependencies, Application and Networking Architecture, Memory Dependancies, Performance Tuning Tools, Tracing SQL execution, Oracle Enterprise Manager, SQL Tuning Advisor & Baselines, Histograms and Bind Peeking, Optimizer Statistics, Thumb rules, SQL Tuning Oracle 11g - AWR report Analysis help. Oracle Enterprise manager 11g provide a GUI Report for Automatic workload repository but i want to know which dynamic and oracle system level view used for AWR Report. 02 Violin Memory Proprietary on Ubuntu Desktop Linux 14. When choosing start and end snapshots for such report, one should take into account application workload periodicity. 2 Load Profile 3. Determine if your database can benefit from IBM FlashSystem Deep, Optimized, Best of Breed ASH. The first section of an AWR report shows general data about the instance; look at figure 1 for an example header section. Please take a look at below links at start. . A snapshot is a set of information regarding performance and resource usage of the database over a period of time. Oracle Database Tips by Donald BurlesonMay 16, 2015 Report Summary: This gives an overall summary of the instance during the snapshot period, Wait Events: This AWR report section provides more detailed wait event information for Apr 6, 2015 Snapshot detail can be found in "dba_hist_snapshot" view. Automatic Workload Repository (AWR) is a collection of persistent system performance statistics owned by the SYS user. The quickest way to capture the SQL being processed by a session is to switch on SQL trace or set the 10046 event for a representative period of time. Its currently in Beta but you can access this service for free using the form below: Performance Tuning With Oracle ASH and AWR. Oracle Installation The Oracle’s Automatic Workload Repository (AWR) collects, processes, and maintains performance statistics for problem detection and self-tuning purposes. März 201821. 1. Table of contentsORACLE AWR REPORT ANALYSIS. SWAP space recommendation from Oracle corp. m. That is MANDATORY and the result of your analysis will be the classic TOP 10 SQL with the worst performance. info-trek. It’s actually very simple. Problem - Automatic Workload Repository (AWR) snapshots cannot be taken in a read-only standby environment. 9:00 a. The VMAX All Flash offers a combination of ease of use, scalability, high performance, and a robust set of data services that makes it an ideal choice for Oracle database deployments. Tailor your resume by picking relevant responsibilities from the examples below and then add your accomplishments. The AWR header was expanded to include data about the platform, CPUs, cores, and sockets, as …[bluemix-analytics] Unable to get user profile from the cloud consoleOnce AWR Report is generated in Oracle, the next task is to analyze it. AWR Baseline Enhancements in Oracle Database 11g. ” I also promised that we would begin to focus a little more deeply into some of the new features in future articles. 1. 10 Steps to Analyze AWR Report in Oracle As you have Generated AWR Report in Oracle , Next task is to Analyze AWR Report in Oracle . You can generate an AWR Compare Periods report from 10:00 p. Determine if your database can benefit from IBM FlashSystem Jun 1, 2017 There are many YouTube videos available. The AWR is a powerful tuning tool The AWR is a powerful tuning tool Explore the Oracle AWR in detail. Could any one please help me on it, any documents/URLs regarding the When I create an awr report within two snapshots say 24139 and 24140 , I get from the part of "SQL ordered by Elapsed Time" the following information: SQL ordered by Elapsed Time DB/Inst: DEVC/DEVC Snaps: 24139-24140-> Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. 21. We are going to choose to use the ASH report instead of the SQL_ID specific AWR report OR a full AWR report for a couple reasons: When IO wait time increases then oracle will spend more time for IO which results in higher DB time. One thing to notice, the difference between the AWR Report from command line and OEM interface is that at the command line, text based report can be chosen. AWR report analysis in depth-part 1 By debasis maity Last updated on March 15, 2018 April 28, 2018 1. AWR analysis: another case study A few weeks ago, I received a request to review an AWR report for a database suffering from instance-level performance issues. •New metric for Oracle performance analysis Database time is total time spent by user processes either actively working or actively waiting in a database call. Automatic Database Diagnostic Monitor (ADDM) in Oracle Database 10g. 10. Michael Messina Management Consultant with TUSC Slideshow 2988798 by heraAn explanation of IOPS and latency In the start of your post you mention 15,000 IOPs then show a screen shot from an awr report that shows physical reads at 14,676 per second. Read honest and unbiased product reviews from our users. It is not a commitment to deliver any material, code, or functionality , and should not be relied upon in making purchasing decisions. It offers real-time database performance monitoring features but lacks the capability of providing in-depth analysis of AWR & ASH data. It helps to minimize the risk connected with maintaining and scaling-up production environments while simultaneously implementing perpetual learning of the managers. Michael R. Oracle AWR report in-depth analysisAs you have Generated AWR Report in Oracle, Next task is to Analyze AWR Report in Oracle. This standard Oracle elapsed time report has evolved over the past 12 years and had several names: § report. AWR Report Analysis I've access to AWR, we are using Oracle 11G, can't access the forum portal from my office, restricted environment, sorry about it, please give Interpreting RAC AWR reports. - Enterprise …Use the Oracle GoldenGate troubleshooting tools like Knowledge Documents, Documentation, SHOWSYNTAX parameter and the Log dump utility. DB2, allows administrators to run maintenance tasks, such as backups, space reorganization, etc. 000. Step 4: Workload Repository Reports Usage If you are new to the AWR reports, the first thing you should probably do is run the ADDM report. But in reality this is not possible always. § The starting snapshot number is 2900. It is installed automatically, has some fairly reasonable default settings, and brings us Active Session History as well. This kind of test would be enough if the DB has no other activity, but I am not allowed to …The use of alert logs, user trace files, and wait events analysis are also explored in this introduction to performance tuning. • List of transactions found (commits and rollbacks). The resulting report can be opend in a browser or text editor accordingly. Oracle AWR report Analysis 2. As the definition SQL Ordered by Version Count - AWR reports statements with more than child cursors than the threshold value which defaults to 20. Updated December 2014. Oracle DB Tuning & Troubleshooting - Interpret an AWR Report 3. Oracle 12cR2: AWR views in multitenant. • Top 5 Timed Events • Oracle Time Model, Wait Classes, & Metrics • Interpreting AWR 3. com/technetwork/database/manageability/diag-pack-ow15 Mar 2018 Let me create a test case : I will take different OS statistics and run time statistics to compare with AWR report generated after execution. Choosing 5 pm and 8 pm will result in the AWR report being diluted by 1 hour and 55 minutes of normal running. IntroductionThis document will introduce and explain the main parts of an Oracle AWR report. How to understand AWR report. analysis. Till now i am working as an administrator now i have moved to performance tunning team for that i need your help and support that how to read and analyse the AWR Report pls help us. This further become novelty if AWR reports are done on Exadata. 7. This section contains detailed guidance for evaluating each section of an AWR report. DB time is the cumulative time spent by database server in processing user requests. tutorialspoint. trackback. If the AWR report is generated to get a general feel of the database profile, then it’s preferable to chose the period of a peak load, since potential performance bottlenecks are more likely to manifest themselves at such times. txt: In Oracle7 and Oracle8, Automatic Workload Repository (AWR) in Oracle Database 10g. Ault Oracle Guru - Nuclear Navy 6 years - Nuclear Chemist/Programmer 10 years - Kennedy Western University Graduate - Bachelors Degree Computer Science - Certified in all Oracle Versions Since 6 - Oracle DBA, author, since 1990. com. The ASH report is available through EM and can also be created by directly calling a PL/SQL procedure in the DBMS_WORKLOAD_REPOSITORY package or by using a supplied SQL*Plus script (ashrpt. Hi, I am using oracle 10g, i want to know how to interpret the AWR Report. Then I can’t advise to use those advisors. oracle. Senior Oracle Database Administrator. scribd. Ask Question 2. Log file sync : This wait event indicates frequent commits (commit frequency is more). Part 1 : What, When and How Virtathon 7/2011 Uday Moogala Vlado Barun Oracle interview questions !!! Working with AWR - Oracle 10g for Performance tuning in Oracle AWR The Oracle 10g database introduces a new framework for managing many tuning tasks automatically, for producing real-time information about the database's health, and for extending advisories to improve performance. Reading the AWR Report. Table of Contents How to understand AWR report in Oracle11g? AWR VS STATSPACK Reports in Oracle 11g Dataguard and RAC Background processes in oracle 11g Background Process in Oracle How to resize the redo logfile /online redo logfile in Oracle 11g? Basic Performance Analysis using AWR data I've previously covered a number of queries that can be combined together to pull out key statistics from the Oracle AWR data for each snapshot it makes, which you could use to analyse the performance of a system. 2011 · This Oracle database or instance crashes can occur on any OS platform with Oracle Server Enterprise Edition from version 10. Welcome This is the entry point for the Oracle Scratchpad - a static page that indexes various 'non-blog' pages on this site and a few other sites. The input is a set of AWR reports in TEXT format and the output is a CSV file. In this blog post, I will cover some of the items reviewed in an AWR and Statspack report when performing an initial, cursory assessment of an instance and server before a more involved analysis. A common latch in transaction heavy databases (the ones that I work in are) is the "In memory undo latch" which allows you to rollback. ppt), PDF File (. A little thought for those who use OEM to generate AWR reports – if you generate the standard HTML form and then try posting it into (say) the OTN database forum when you want some help interpreting it, it won’t look very readable (even if you do remember to put the right tags before and after to reproduce it in fixed font). the. In this blog post, I will cover some of the items reviewed in an AWR and Statspack report when performing an initial, cursory assessment of an instance and server before a more involved analysis. It is intended for information purposes only, and may not be incorporated into any contract. Generate AWR report for a particular SQL Once you have identified that a particular SQL is causing issues, you can generate the AWR report for a particular SQL between two specific snap_id's for further analysis. Using AWR report to find IO latency and performance issues. com/articles/10g/automatic-workload-repository-10gIn Oracle 10g statspack has evolved into the Automatic Workload Repository (AWR). Thanks PradeepOracle Statistik Reports Leitfaden zur Auswertung Angelika Gallwitz freiberufliche Beraterin Bad Homburg Schlüsselworte Statspack Reports, AWR Reports, Top 5 Timed Events, Baseline, Tuning, Thresholds, Wait ClassWhen looking at an AWR report, a good place to start is the "Top 5 Timed Foreground Events" section, near the top of the report. An AWR contains 3 primary sections – (1) Oracle Configuration Details (2) Performance Statistics and (3) Advisory. AWR Snapshot Reports Oracle provides reports that you can run to analyze the data in And i need how to analysis table,user,schema level and how can query for that The Automatic Workload Repository takes "snapshots" of database performance statistics periodically, and records these data for later review. AWR report analysis In 8i, oracle has introduced a primitive version of statspack report and enhanced the capabilities of statspack report in version 9i. ) awrddrpt. AWR reports can be generated by running various SQL scripts to satisfy various requirements. As a Software Engineer, he developed and managed numerous projects in multinational companies such as Hewlett-Packard. This course helps to prepare you for the Oracle Database 11g: Performance Tuning exam which counts towards the Oracle Database 11g Performance Tuning …Space Management — Growth trend analysis, fragmentation analysis, disk configuration, segment space utilization monitoring, datafile sizing, and Oracle data object segment sizing. • I/O core waits including schema objects affected (tables, indexes, partitions), when traced with level 8 or 12. 1 64-bit. txt) or view presentation slides online. It is AWR Report Detailed Analysis Mike Ault Oracle Guru Texas Memory Systems. 7:00 a. Graph the key metrics. Oracle AWR report in-depth analysis [bluemix-analytics] Unable to get user profile from the cloud console Once AWR Report is generated in Oracle, the next task is to analyze it. From Oracle10g onwards, the Automatic Workload Repository has provided powerful tools to help the DBA identify and resolve performance issues without the hassle of analyzing complex statistical data and extensive reports. Proof of Concept experiences for Oracle …Diese Seite übersetzenhttps://manualzz. 1 Like 19,298 Views 4 Comments . For oracle database, it is there in tcode DB02 > Wait Event Analysis > Workload Reporting. it’s better to have four reports each for one hour. for Oracle 11g Release 2 If RAM is between 1 GB and 2 GB, SAWP Performance Tuning Using AWR, ASH and ADDM. Package the analysis results into a single report. This means that 700 minutes of time is spent by the sessions on waiting. If you ever noticed a high miss rate on this type of latch, you would want to examine not only the total number of SQL events Oracle AWR report Analysis Table of contents. Though It's a lengthy report but Analyzing or Reading relevant part of AWR Report can help to troubleshoot issues in easy and fast manner. 000 user manuals and view them online in . Make sure you have the correct licensing before using this functionality. Oracle 10 g introduced a new background process, MMON (Manageability Monitor), to do this work. Find helpful customer reviews and review ratings for Oracle Performance Tuning: Database Management Systems (Nutshell Handbooks) at Amazon. I really think that it makes more sense to read an AWR report at CDB level because it’s about analysing the system • Automatic Workload Repository (AWR) •Is the Oracle performance warehouse •AWR allows the collection and analysis of performance data •Offers more Information than statspack •Enterprise Manager - Cloud Control •Graphical web-based console which provides a single, integrated solution for administration, How to read AWR report? The stress on the Oracle server is important, Labels: Performance Analysis. 01. ASH comes to the rescue! ASH comes to the rescue! Even DBAs who are familiar with ASH have a difficult time using ASH to directly answer key management issues surrounding a performance incident. , during a predefined window, typically during non-peak Usable on Standard and Enterprise Versions. 2012 · The AWR/Statspack report should be taken for the interval not more than 60 minutes during problem. Mit dem Real-Time SQL Monitoring kann die Performance einer speziellen SQL Abfrage …AWR reports (Part I) – 10 most important bits. In Oracle AWR report how to use “Latch statistics” section in analysis. I don't find any such option in SAP level for DB2 database (in DB02). A Layman's guide to quickly interpreting Oracle AWR reports. Oracle AWR report in-depth analysis. Home » Articles » Misc » Here SQL trace, 10046, trcsess and tkprof in Oracle. com for a sample AWR analysis. Also try www. 5 SQL Section 6. [Oracle-l] AWR snapshots empty - ADDM runs fail; Running AWR reports results in stacks of warning messages and trying to display the ADDM runs (hourly) shows an Luckily, Oracle has in-built mechanisms to help DBA’s quickly identify performance bottlenecks – the Automated Workload Repository (AWR). Oracle GoldenGate in the AWR report?–A bit misleading December 11, 2013 · by Bobby Curtis · in Database , Golden Gate · Leave a comment Today while I was doing reviews of AWR reports on a database, I came across a wait event that I was a bit surprised to see. pdfHost Name Platform CPUs Cores Sockets Memory (GB) maclean1. Any snapshot over 60 0mins may not be ideal for performance analysis (can be changed though) as it can hide the actual issue. By Reading AWR Report you can easily solve issues like Slow database, high wait events, Slow query and many more. Days to report. DbaKeeda. 10 comments. AWR reports (Part I) – 10 most important bits. 1 Total Elapsed Time 7 The data in an AWR report is the delta, or changes, between the accumulated metrics within each snapshot. IBM Systems. 2015 · Two Queue Or Not To Queue, That Is The Question will help you tune Oracle systems faster and with a greater depth of understanding. This gives you an indication of …Understanding all of the sections of a STATSPACK report is quite complicated, and I have a whole chapter dedicated to reading a STATSPACK report (and the AWR report) in my new book "Oracle Tuning: The Definitive Reference". 2. The insights you gain proAutor: OraPub, Inc. What is the approach to analyze the AWR report for a specific SQL statement's performance in an Oracle DB server for a bottleneck analysis? The data in an AWR report is the delta, or changes, between the accumulated metrics within each snapshot. Dadurch hat der Administrator die Möglichkeit, die Performance der Ausführung der Datenbankabfragen nachträglich zu überprüfen. “24” will provide one row for each day, “6” will give 4 rows a day. § The instance number for RAC is 1. When running the AWR Report from OEM, the only option is the report is automatically saved in HTML format. by Ramakanta · Published July 9, 2012 · Updated September 30, 2016. In the post Automatic Workload Repository (AWR) Performance Monitoring Tool Basics , I described the basic set up and report generation for AWR. Introduction 3. oracle awr report in depth analysis 2. Correct me if I am wrong I’ve always thought that IOPs from an AWR were calculated using the following statistics from awr: physical read total IO requests + physical write total IO requests (assuming 10. com/videotutorials/index. ADDM analysis is performed every time AWR snapshot is taken and the results are saved in database. Interval in hours. AWR holds historic past snapshot intervals and the session performance statistics for analysis later. 1 The snapshot details 3. AWR Report analysis; Thanks for the question, oracle. Analyzes AWR data automatically after an AWR snapshot. • Extensive handy experience in db administration, backup/recovery, Dataguard, Streams, database cloning, Oracle High Availability, migration Titel: Certified ORACLE RAC DBAKontakte: 76Branche: Information Technology and …Ort: Dallas/Fort WorthTraining PPT | Oracle Database | SqlDiese Seite übersetzenhttps://es. And it does not tell you whether your database was well behaved or not. Reading an AWR report id difficult because most of the metrics are undocumented because the AWR report was originally designed for Oracle support internal-use only. Also I did not find any related SAP note how to configure AWR report in DB2. 1 Total Elapsed Time 7 The AWR came about in Oracle 10g and before that there was the STATSPACK reporting schema which contained many similar functions to the AWR but it was much more basic and did not have nearly as many functions as the AWR has, especially in terms of integration with other functionality in the database. I have collected 10 points which can be checked for the very first step in your analysis. No comments: Post a Comment. Oracle AWR report in-depth analysis . If you continue browsing the site, you agree to the use of cookies on this website. 0. AWR report analysis in depth-part 2 By debasis maity Last updated on March 20, 2018 March 31, 2018 This document is continuation of AWR report analysis in depth step by step which will provide you an idea to understand AWR report more quickly. (available since Oracle 10g) AWR collects (through snapshots), processes, and maintains performance statistics. Broad in scope, this course covers all of the Oracle Database 04. AWR report and drill down into the later sections as indicated by the wait events and latch data. • Oracle errors if any. Oracle AWR reports uses snapshots to collect/record data from database. There are many YouTube videos available. I understand that physical I/O is the most expensive component and …AWR ReportsIntroduct ionDif ferences between AWR and StatspackWorkload Repository ReportsAWR Snapshots and BaselinesQuick Summary on AWR Sect ionsReading the AWR Report - Header Sect ion: - Cache Sizes - Load Prof ile - Instance Eff iciency - Shared Pool Stat ist ics AWR Generator: SQL script for generating multiple AWR Reports. In this post, we will talk more about what are all that has been taken into consideration in AWR Report Analysis in Performance Testing When you create an AWR report in Oracle DB, we are asked to In Oracle 12c werden Daten aus dem Real-Time SQL Monitoring, Datenbank Operations Monitoring und dem Real-Time ADDM Reports ebenfalls in das AWR der Datenbank abgespeichert. Specific reports can be produced by Oracle AWR report Analysis Slideshare uses cookies to improve functionality and performance, and to provide you with relevant advertising. AWR Data. AWR This are the detail about snap shot taken, Snap start time and end time. 02. Check the “DB Time” metric. pdf), Text File (. Oracle AWR report in-depth analysis http://www. Oracle Golden Gate 12c brings extreme performance with simplified configuration and management, tighter integration with Oracle Database, support for cloud environments, expanded heterogeneity, and enhanced security. The AUTOMATIC WORKLOAD repository is a source of information for several other Oracle 10g features including : -Automatic Database Diagnos frm-92050 failed to connect to server /forms/lservlet-1 ERROR frm-92050 failed to connect to server /forms/lservlet-1 SOLUTION 1. In Oracle 10g, instead of a Statspack report, an Automatic Workload Repository (AWR) report is generated, which provides more data and other benefits. ASH report or Active Session History report is a very important feature to analyze sessions in Oracle to troubleshoot transient problems that last for just few . If you want to use the more traditional blog entry point you can bookmark this URL for ordinary postings. This video will show users how to setup and run an optimization in MWOffice. If it is much higher than the elapsed time, then it indicates that the sessions are waiting for something. com/technetwork/database/manageability/diag-pack-owHere are 10 easy steps to analyze AWR Report or Read AWR Report in Oracle. sql – Produces the AWR report for the current (local) database and instance. The script prompt you to enter the report format (html or text), the start snapshot id, the end snapshot id and the report filename. I always advise to focus the performance analysis on a short period where activity is regular. -Place redo log file in faster disks. Oracle AWR report in-depth analysis . What you will learn in this Oracle Golden Gate online training Course? Oracle Golden Gate is a comprehensive software package for real-time data integratioWhen viewing AWR report, always check corresponding ADDM report for actionable recommendations. com: Linux x86 64-bit: 4: 4: 1: 9. Follow RSS feed Like. If ASMM/AMM is not enabled, if the hit ratios are less than Reading AWR Report. This article describes several methods for producing reports from the Automatic Database Diagnostic Monitor (ADDM) in Oracle 10g. Installation of Oracle 12c database on Oracle Enterprise Linux – 6. Collect Multiple AWR Reports: It’s beneficial to have two AWR Reports, one for the good time and other when performance is poor or you can create three reports (Before/Meantime/After reports) during the time frame problem was experienced and compare it with the time frame before and after. AWR Report Detailed Analysis Mike Ault Oracle Guru Texas Memory Systems. Even though the report is lengthy, Analyzing or Reading relevant part of AWR Report can help to troubleshoot issues in easy and fast manner. Interpreting AWR Report Ideally, oracle recommands to have the hit ratio greater than or equal to 90%. • ADDM Report: Provides in-depth performance analysis • AWR, ASH Report: Facilitates comparative or skew analysis. Oracle collects information all the while and save this data while the snapshot happens. How to Analyze or Read OS Watcher Output in three How to Troubleshoot ORA-00600 and ORA-07445 Intern 10 Tips for Oracle Database Security Best Practice 10 Steps to Analyze AWR Report in Oracle; DBA VIEW: Top 10 to keep Handy April (8) March (13) February (7) January (18) 2012 (23) How to create an Oracle AWR report with SQL and PL/SQL AWR is a great tool (but needs diagnostics pack). 1 Total Elapsed Time 7 Automatic Workload Repository – AWR Reports –In-depth SQL performance analysis Real-Time SQL Monitoring aggregated AWR and ASH data Supports Oracle EE The AWR came about in Oracle 10g and before that there was the STATSPACK reporting schema which contained many similar functions to the AWR but it was much more basic and did not have nearly as many functions as the AWR has, especially in terms of integration with other functionality in the database. ADDM is a self diagnostic engine designed from the experience of Oracle’s best tuning experts. 2) Instance: read once, twice or three times the AWR looking for issues. 3 Comments Posted by (AWR), introduced in Oracle Database 10g, is a self managing repository of data that is used internally by Oracle to self-diagnose and tune. By admin on October 8, 2018 DBA. Current Restrictions • Database Replay does not support the following features in the current release • SQL Loader direct path load, import/export • OCI based object navigation (ADTs) and REF binds • Streams, non-PL/SQL based AQ • Distributed transactions, remote What I Need to Know When Upgrading - Download as Powerpoint Presentation (. Oracle AWR report in-depth analysis Once AWR Report is generated in Oracle, the next task is to analyze it. AWR Report Detailed Analysis Mike Ault Oracle Guru Texas Memory Systems. The ADDM report provides root cause analysis of the parts of the system IBM Systems. statspackanalyser. MMON. The decision to use Statspack or AWR is made based on what the client is licensed for. 2012 · DB2. sql script is used to generate addm report. Download Presentation Oracle Database 11g Real Application Testing An Image/Link below is provided (as is) to download presentation. About The Course This Oracle DBA training course is an intensive hands-on course is designed to provide Oracle professionals with an in-depth understanding of the DBA features of Oracle, specific Oracle concepts and knowledge required for the OCP exam, and tips and techniques for passing the Oracle OCP exam on your first attempt. Database System & My Life « Thinking in Resizing Redo Log. Several tools such as ADDM (Automated Database Diagnostic Monitor), AWR Reports analyses the snapshots to perform performance analysis against a baseline snapshot. In this tutorial one can learn what is the difference between AWR and ASH Reports in Oracle database, ASH can help you when there's a sudden performance degradation of the database felt. The comparison of these reports should identify configuration settings, workload profile, (available since Oracle 10g) AWR collects (through snapshots), processes, and maintains performance statistics. If they only need to do 10 a second and they spend half the day on Youtube, you are doing fine. self-management decisions made by Oracle Database 11g are always specific to the environment that the database is operating in. This book includes scripts and tools to hypercharge Oracle 11g performance and you can buy it for 30% off directly from the publisher. Cross check against common “rules of thumb” from the Oracle Gurus. Part 1 How And What 1. AWR/Staspack is a kind of profiling in Oracle database in order to identify the performance bottlenecks. Automatic Database Diagnostic Monitor(ADDM) can analyze performance issues during a particular period and provide suggestion. A Texas Memory …Want to be notified when our article is published? Enter your email address and name below to be the first to know. Snapshot 1 . AWR Report Analysis I've access to AWR, we are using Oracle 11G, can't access the forum portal from my office, restricted environment, sorry about it, please give This section contains detailed guidance for evaluating each section of an AWR report. Practical experience in performance troubleshooting, using Oracle dictionary views, AWR report, understanding of query execution plans: 1+ years Data querying and analysis skills, knowledge of Oracle analytical functions07. 8 (23 ratings) Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately. 4 The time model statistics 5. Performance Tuning for Oracle 10g/11g database This discusses running the AWR Analyzer v3. Here are the the key parts of that report (with some masking): The awr-parser. In my opinion, that a bug. Just an observation… Reason 1 – user doesn’t need a lot of Oracle knowledge. 0. Oracle AWR report AnalysisTable of contents 1. The AWR SQL Detail Report When AWR …Center of Knowledge, Path to Success Website: www. Look for correlations (Db time proportional to TX – row lock contention?). Read the reports. You made it very simple to understand first 2 tables in AWR on which remaining analysis of report Understand Performance of Oracle Database using AWR Report. Long-Term Performance Repository – Delivers unlimited performance and environmental data storage and dimensional analysis in an Oracle database. The findings (problems) are listed in order of potential impact on database performance, along with recommendations to resolve the issue and the symptoms which lead to it's discovery. sh script (available here) is a tool for extracting data from Oracle AWR reports in order that it can be plotted in graphical form. Asked: February 03, 2016 - 5:55 am UTC "Currently i am generating AWR Report and check the top 10 Automatic Workload Repository (AWR) in Oracle Database 10g list of the top five findings from the last ADDM analysis task. 4 to 11. 0 Database Details: After getting an AWR Report check the report generated is for the problematic DB. Storage Management — Disk configuration, determining stripe sizes, and I/O bandwidth monitoring. awrrpti. 7; AWR report analysis in depth-part 1 0. This will help to isolate the problem. Hence the ratio above 80% is always healthy. Senior Oracle DBA, Oracle 10g , Oracle 11g OCE ,Oracle 12C and Oracle 11g OPN certified Specialist, OCP Certified in Oracle AWR report in-depth analysis . 2 on any platform. Guide the recruiter to the conclusion that you are the best candidate for the oracle pl-sql job. It resides in SYSAUX tablespace and by default snapshots are generated once every 60min and maintained for 7 days. I have to do a manual analysis ( like statspace manual analysis). See here for more notes on reading a STATSPACK/AWR report. AWR/Statspack is a report of performance related database statistics for given snapshots (period of time). 8:00 a. 03. Oracle DBA Interview Questions and Answers - Performance Tuning What to Look for in AWR Report and How to find SQL,SQL_ID history on Oracle; Oracle In May 2017 Dell EMC announced VMAX 950F, which replaces the VMAX 450F and 850F by providing higher performance at a similar cost. Consider this article to be the first of For the last six years, several regional user groups including the Virginia Oracle Users Group, the Eastern States Oracle Applications Users Group, the Hampton Roads Oracle Users Group, and the Southeastern Oracle Users Group have joined together to co-host the East Coast Oracle Users Conference (ECO). read lessspAnalyzer is a tool which provides analysis of text report files generated by Oracle Automatic Workload Repository (AWR) and STATSPACK tools. 55Understanding AWR Report June 13, 2012 Posted by Mich Talebzadeh in Oracle. htm Lecture By: Mr. Work with a world class team to provide enterprise-wide, Oracle Database Administration support for production systems and provide DBA services to application development teams, including database design, database generation, coding, and database production support. When using AWR report to troubleshoot a specific issue, it is a good idea to generate a second report to as a point of reference. When a block is requested by a query, Oracle looks for it in the Buffer Cache and if found, it results in a Logical read and if it does not find the Block in there it results in a physical read (disk I/O). Expert instructors will teach you how to identify the causes of slow startups, evaluate lag statistics and solve network and disk bottlenecks. Capabilities • Upgrade path SW recommendations w/ • • Certification /EOL checks Recommended Patches Replacement/Merge Patch Conflict Analysis for Patches Research and Add Patches Value • Reduced Time in research, analysis and management of Upgrade Plan • Reduced Risk due to increased accuracy (automated analysis) • Improved quality of plan due to latest Oracle Advice, Best There is no time for more in-depth performance analysis so I decided to do very simple test: I execute 40 000 000 rows insert and measure the time of the operation before migration and after. Usable on Standard and Enterprise Versions. At regular intervals, the Oracle Database makes a snapshot of all of its vital statistics and workload information and stores them in the AWR. sql - Basic AWR report (generates an HTML or text report that displays statistics for a range of snapshot Ids. That should be called : Oracle Application’s Performance Tuning . Please take a look at below links at start. • Gaps of no trace activity found on file. As Oracle now offers automatic performance tuning capabilities, the focus of this function is the new statistics collection facility, called the automatic workload repository (AWR). AWR report analysis in depth-part 1 By debasis maity Last updated on March 15, 2018 April 28, 2018 1. An AWR report outputs a …08. Oracle's Automatic Workload Repository improves quite a lot on it's previous statspack (which is still available for those diehards out there). It will summarize all AWR snapshots starting with “trunc(sysdate)-{days to report}+1”, so if you pass “1”, it will summarize all snapshots from today, if “2” – than it’s yesterday and today are included. AWR is a successor of statspack and it was introduced in 10g version of oracle. Please dont take AWR / Statspack report for duration …How to read an AWR report Oracle Tips by Burleson Consulting. 2012 · DB2 Vs. Choosing a baseline report. com Oracle GoldenGate 12c: Troubleshooting and Tuning 170217 ORACLE GOLDENGATE 12C:Oracle Performance Tuning Tools. . Requires Management Tuning Pack License from Oracle. free buffer waits because of slow disk IO. com/doc/36795339/proof-of-concept-experiences-forSearch among more than 1. If the wait event is because of data block, move the segment to a tablespace where the block size is small. Case Sensitive in Oracle Agent 10g Command Line » Thinking in ORA-494, ORA-239 Instance Crashes and Hangs…. Here, I am not focusing on a single issue but providing an overview instead. Issues that could have …This Oracle GoldenGate 12c Troubleshooting and tuning training teaches you how to gather and examine evidence; you’ll also learn to solve case problems, diagnose their cause and find methods of …spAnalyzer is a tool which provides analysis of text report files generated by Oracle Automatic Workload Repository (AWR) and STATSPACK tools. As you have Generated AWR Report in Oracle, Next task is to Analyze AWR Report in Oracle. I described the first article as “a view from 30,000 feet. This kind of analysis is not available to DB2 DBAs. Mohan's Oracle 11g DBA Concepts. An ADDM analysis is performed on a set of awr snapshots. It can create very useful reports for performace analysis over a given period. AWR= Automatic Workload Repository Introduced in Oracle 10g Evolution to statspack, requests for performance reporting improvements. Latch Hit %: Shows % of time latches are acquired without having to wait. Each report is available in HTML or TXT format: — awrrpt. Once AWR Report is generated in Oracle, the next task is to analyze it. oracle. Feb 7, 2017 An AWR report is primarily useful in gathering data on the Wait Events, Active to analyze at once, for someone not making a living out of doing so! and ADDM report recommendations for getting an in-depth information of Mar 16, 2018 Real Time – AWR Report Analysis watch more videos at https://www. [bluemix-analytics] Unable to get user profile from the cloud console AWR report analysis in depth-part 2 By debasis maity Last updated on March 20, 2018 March 31, 2018 This document is continuation of AWR report analysis in depth step by step which will provide you an idea to understand AWR report more quickly. AWR and Performance An in-depth performance study was conducted to measure the impact of automatic manageability features in Oracle Database 10g Release 1. 07. ID#: S307988 Centralize Your Automatic Workload Repository Data for Better Analysis. 04. sql - Period diff on current instance (generates an HTML or text report that compares detailed performance attributes and configuration settings between two selected time periods) Understand Performance of Oracle Database using AWR Report. AWR and ADDM Reports AWR and ADDM - best explanation The AUTOMATIC WORKLOAD repository is a source of information for several other Oracle 10g features including : -Automatic Database Diagnostic Monitor -SQL Tuning Advisor -Undo Advisor -Segment Advisor When I create an awr report within two snapshots say 24139 and 24140 , I get from the part of "SQL ordered by Elapsed Time" the following information: SQL ordered by Elapsed Time DB/Inst: DEVC/DEVC Snaps: 24139-24140-> Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. The ADDM report provides root cause analysis of the parts of the system consuming the most time. How to read and understand AWR report for slow disk IO. § The ending snapshot number is 2911. The data in an AWR or STATSPACK report is the delta, or changes, between the accumulated metrics within each snapshot. In other words, dealing with a buffer busy situation involves multiple sessions contending for the same block requires tuning that is similar to dealing with buffer busy waits or read by other sessions in Oracle RAC environment. Over 5 years of experience in AWR report analysis. If you look at any AWR or Statspack report in the "Time Model" section, you will see DB CPU. DBspeed focuses on time-series analysis and dimensional analysis of AWR & ASH data in DBA_HIST views (usually called historical performance data). - Performance monitoring and analysis is limited to basic STATSPACK functionality . A Texas Memory Systems Presentation Michael R. Remember: The best performance comes from the unnecessary work you don't do. A Texas Memory Systems Presentation AWR Report Header WORKLOAD REPOSITORY report for Introduced in Oracle 10g and having evolved from the Statspack functionality of Oracle 8i/9i, the Automatic Workload Repository report or AWR report (as it is more commonly known as) is a vital I am working as an oracle database administrator with SQL database also. Oracle 10g AWR Report analysis I've gathered 32 AWR reports at 15 mins interval, from these 32 reports, have extracted 5 top intervals, my criteria for making an interval candidate for performance tuning is because of DB Time, the max DB time is top interval. sql ( 11g Release 2 and above ) - Produces the Global AWR report for all available instances in an Oracle Real Application Clusters (RAC) environment. AWR (Automatic Workload Repository) is a built-in repository (in the SYSAUX tablespace) that exists in every Oracle Database. Learn Oracle Golden Gate Training at OnlineTrainingIO. Reading the AWR Report This section contains detailed guidance for evaluating each section of an AWR report. I’ve made an excel sheet (attached) with my gathering of information. These events are helpful during analysis of any Steps to Analyze AWR Report in Oracle April 6, 2015 August 21, 2015 ~ llnarayan AWR – Automatic workload repository is a collection of persistent system performance statistics owned by SYS. Here are 10 easy steps to analyze AWR Report or Read AWR Report in Oracle. oracle awr report in depth analysisDeep, Optimized, Best of Breed ASH. Parth Panjab,  ORACLE-BASE - Automatic Workload Repository (AWR) in Oracle oracle-base. I think that the advisor can do Finnbarr has both breadth and in-depth knowledge of Unix, GNU/Linux, and Oracle with 25+ years of experience in operating system internals development, system administration, application development and project management on a wide variety of hardware and software platforms. Oracle 10g AWR Report analysis. product direction. to 2 a. Statspack usage for reasons 2 and 3 and possibly other uses usually do require (be it good or bad) certain level of Oracle skills. The report generated by AWR is a big report and it can take years of experience to actually understand all aspects of this report. An AWR report is very similar to a STATSPACK report, and it contains vital elapsed-time information …Hi tom, I am working as an oracle database administrator with SQL database also. What is the approach to analyze the AWR report for a specific SQL statement's performance in an Oracle DB server for a bottleneck analysis? The resulting report can be opened in a browser or text editor. • Top 5 hot blocks, indicating the schema objects (l 8 I have a vendor that insists on running a batch job with statistics_level='ALL' and event 10046, level 8,both set at the session level in *production* only to diagnose performanceGeneral Oracle database Performance Tuning FAQ. Steps to Analyze AWR Report: Note: The Report is obtained using OEM with Oracle Release 12. The landmark book "Advanced Oracle SQL Tuning The Definitive Reference" is filled with valuable information on Oracle SQL Tuning. - Experience in Oracle Database Administration ,software development, analysis, design, implementation and support of computerized systems. If database host is CPU bound then sessions will wait on active run queue resulting increase in DB time. Automatic Workload Repository (AWR), a licensed feature of Oracle, is one of the best tools to monitor the performance issues. AWR Analysis Since the introduction of statspack and then AWR reports, it has become a specialist skill to be able to analyse these reports. You can look at it in the few following days after instance startup, just to have an idea, but don’t rely only on that. AWR report parts 3. Analyzing AWR reports for oracle AWR report generates the performance statistics related to database server like system and session statistics, segment usage statistics, resource intensive SQLs, time model statistics and buffer cache details. An AWR report is very similar to a STATSPACK report, and it contains vital elapsed-time information on what happened during particular snapshot range. Equally, if that measurement is for eight hours of a working day, it could be a very different story if it covers 24 hours where everyone is home for 16 of them. Generating Various Types of AWR Reports. 20187 Feb 2017 An AWR report is primarily useful in gathering data on the Wait Events, Active to analyze at once, for someone not making a living out of doing so! and ADDM report recommendations for getting an in-depth information of 6 Apr 2015 Snapshot detail can be found in "dba_hist_snapshot" view. The development, release, and timing of any features or functionality described for Oracle’ s products remains at the sole discretion of Oracle How to generate AWR report from Oracle Database. can user which have a sysdba role to see all tables used in AWR Report? You will also be asked for the format of the report (text or html) along with the report name. 100% Course Satisfaction by our professional trainers. 2018 · Instead of having one report for long time like one report for 4hrs. This is also the URL for the page referenced to the…11. Senior Oracle DBA, Oracle 10g , Oracle 11g OCE ,Oracle 12C and Oracle 11g OPN certified Specialist, OCP Certified in An AWR Report tells you what happened on your database between the two snapshots used. As per Oracle AWR report the target should be 100% for these ratios. Using Statspack reports is safest if you are unsure about your Oracle licensing. addmrpt. Location: PH-PH,Philippines-Taguig City. Interesting part here is “DB Time”. AWR (Automatic Workload repository) Report: Automatic Workload Repository gathers, processes and maintains performance stats used for problem detection and self-tuning the databases. Oracle AWR Reports: Understanding I/O Statistics February 26, 2014 37 Comments One consequence of my job is that I spend a lot of time looking at Oracle Automatic Workload Repository reports , specifically at information about I/O. for statspace Creating an AWR Report