You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for ADDM


1 to 20 of 154 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database Performance Tuning Guide, 11g Release 2 (11.2)

SQL Tuning Overview

16.4.1 ADDMThe Automatic Database Diagnostic Monitor (ADDM) analyzes the information collected by the AWR for

Database Concepts, 11g Release 2 (11.2)

Glossary

ADDMAutomatic Database Diagnostic Monitor. An Oracle Database infrastructure that enables a database to diagnose its own performance and determine how identified problems could be resolved.

Database Performance Tuning Guide, 11g Release 2 (11.2)

Automatic Performance Diagnostics

6.1.1 ADDM AnalysisAn ADDM analysis can be performed on a pair of AWR snapshots and a set of instances from the same … define the target for analysis. If you are using Oracle Real Application Clusters (Oracle RAC), ADDM … has three analysis modes: Database In Database mode, ADDM analyzes all instances of the database … . Instance In Instance mode,

Database Performance Tuning Guide, 11g Release 2 (11.2)

Automatic Performance Diagnostics

6.1.3 ADDM Analysis ResultsIn addition to problem diagnostics, ADDM recommends possible solutions. ADDM analysis results are … represented as a set of findings. See Example 6-1 for an example of ADDM analysis result. Each ADDM … information about problems that may affect the completeness or accuracy of the ADDM analysis (such

Database Performance Tuning Guide, 11g Release 2 (11.2)

Automatic Performance Diagnostics

6.2 Setting Up ADDMto NONE disables ADDM. The STATISTICS_LEVEL parameter should be set to the TYPICAL or ALL to enable … BASIC disables many Oracle Database features, including ADDM, and is strongly discouraged. See Also … STATISTICS_LEVEL initialization parameters ADDM analysis of I/O performance partially depends on a single … hard drives are

Database Performance Tuning Guide, 11g Release 2 (11.2)

Automatic Performance Diagnostics

6.3.4 Displaying an ADDM ReportTo display a text report of an executed ADDM task, use the DBMS_ADDM. GET_REPORT function … the ADDM task specified by its task name using the tname variable: SET LONG 1000000 PAGESIZE 0 … to fit line size of 80. For information about reviewing the ADDM analysis results in an ADDM report, see \"ADDM

Database Performance Tuning Guide, 11g Release 2 (11.2)

Automatic Performance Diagnostics

6.4 Views with ADDM InformationTypically, you should view output and information from ADDM using Oracle Enterprise Manager or ADDM … reports. However, you can display ADDM information through the DBA_ADVISOR views. This group of … . This view only displays the ADDM findings discovered by all advisors. Each ADDM finding is displayed

Database Performance Tuning Guide, 11g Release 2 (11.2)

Automatic Performance Diagnostics

6.1.4 Reviewing ADDM Analysis Results: ExampleConsider the following section of an ADDM report in Example 6-1. Example 6-1 Example ADDM Report … sample statements. When a specific problem has multiple causes, the ADDM may report multiple problem … findings can exceed 100% of DB time. For example, if a system performs many reads, then ADDM might … impact.

Database Performance Tuning Guide, 11g Release 2 (11.2)

Automatic Performance Diagnostics

6.3.2 Running ADDM in Instance ModeTo analyze a particular instance of the database, you can run ADDM in Instance mode. To run ADDM in … ADDM task in instance analysis mode, and executes it to diagnose the performance of instance number 1 … ADDM for 7PM to 9PM'; DBMS_ADDM.ANALYZE_INST(:tname, 137, 145, 1); END; /

Database Performance Tuning Guide, 11g Release 2 (11.2)

Automatic Performance Diagnostics

6.3.3 Running ADDM in Partial ModeTo analyze a subset of all database instances, you can run ADDM in Partial mode. To run ADDM in … ADDM task in partial analysis mode, and executes it to diagnose the performance of instance numbers 1 … :tname:= 'my ADDM for 7PM to 9PM'; DBMS_ADDM.ANALYZE_PARTIAL(:tname, '1,2,4', 137, 145); END; /

Database Performance Tuning Guide, 11g Release 2 (11.2)

Automatic Performance Diagnostics

6.3 Diagnosing Database Performance Problems with ADDMTo diagnose database performance problems, first review the ADDM analysis results that are … can run ADDM manually as described in this section. ADDM can analyze any two AWR snapshots (on the … same database), as long as both snapshots are still stored in the AWR (have not been purged). ADDM can … ending snapshot.

Database Performance Tuning Guide, 11g Release 2 (11.2)

Automatic Performance Diagnostics

6.3.1 Running ADDM in Database ModeFor Oracle RAC configurations, you can run ADDM in Database mode to analyze all instances of the … databases. For single-instance configurations, you can still run ADDM in Database mode; ADDM will … simply behave as if running in Instance mode. To run ADDM in Database mode, use the DBMS_ADDM … ADDM

Database 2 Day DBA, 11g Release 2 (11.2)

Monitoring and Tuning the Database

Running ADDM ManuallyBy default, Oracle Database runs ADDM every hour, immediately after an AWR snapshot. Performance … findings from the most recent ADDM run, if any, are listed on the Database Home page. See … ADDM manually. Reasons for doing so include running it as a recommended action associated with an … alert or running it across multiple snapshots.

Database 2 Day DBA, 11g Release 2 (11.2)

Monitoring and Tuning the Database

Responding to ADDM Performance FindingsYou can act upon the recommendations that accompany ADDM performance findings. To respond to ADDM … performance findings: In the ADDM Performance Analysis section of either the Database Home page or … the ADDM page, in the Finding column, click a finding. The Performance Finding Details page appears

Database 2 Day DBA, 11g Release 2 (11.2)

Monitoring and Tuning the Database

Diagnosing Performance Problems Using ADDMADDM or another advisor, as appropriate, to get more detailed diagnostics of system or object … threshold. See the latest ADDM analysis. Rule Name= Rule Owner=SYSMAN The e-mail message contains a link to … the host name and the latest ADDM analysis. By default, alerts in critical state such as DB Down … Performance Problems Using

Database Performance Tuning Guide, 11g Release 2 (11.2)

Automatic Performance Diagnostics

6.1.2 Using ADDM with Oracle Real Application ClustersIf you are using Oracle RAC, you can run ADDM in Database analysis mode to analyze the throughput … performance of all instances of the database. In Database mode, ADDM considers DB time as the sum of … + Real Application Clusters Guide for information about using ADDM with Oracle RAC

Database 2 Day DBA, 11g Release 2 (11.2)

Monitoring and Tuning the Database

Viewing a Summary of ADDM Performance FindingsADDM analysis results consist of a description of each finding and a recommended action. You can … view a summary of findings and their impacts on the system. To view a summary of ADDM performance … Summary section of the Database Home page, locate the numeric link next to the ADDM Findings label … findings from the most recent

Database Concepts, 11g Release 2 (11.2)

Glossary

Automatic Database Diagnostic Monitor (ADDM)See ADDM. Automatic Diagnostic Repository (ADR) See ADR.

Database 2 Day + Performance Tuning Guide, 11g Release 2 (11.2)

Automatic Database Performance Monitoring

ADDM AnalysisAn ADDM analysis is performed after each AWR snapshot (every hour by default), and the results are … performance tuning method described in this guide, review the results of the ADDM analysis first … . The ADDM analysis is performed from the top down, first identifying symptoms and then refining the … analysis to reach the root

Database 2 Day + Performance Tuning Guide, 11g Release 2 (11.2)

Automatic Database Performance Monitoring

ADDM RecommendationsIn addition to diagnosing performance problems, ADDM recommends possible solutions. When … appropriate, ADDM recommends multiple solutions from which you can choose. ADDM recommendations include the … statements or running the Segment Advisor on hot objects ADDM benefits apply beyond production systems … . Even