How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- 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
16.4.1 ADDM → The Automatic Database Diagnostic Monitor (ADDM) analyzes the information collected by the AWR for
ADDM → Automatic Database Diagnostic Monitor. An Oracle Database infrastructure that enables a database to diagnose its own performance and determine how identified problems could be resolved.
6.1.1 ADDM Analysis → An 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,
6.1.3 ADDM Analysis Results → In 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
6.2 Setting Up ADDM → to 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
6.3.4 Displaying an ADDM Report → To 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
6.4 Views with ADDM Information → Typically, 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
6.1.4 Reviewing ADDM Analysis Results: Example → Consider 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.
6.3.2 Running ADDM in Instance Mode → To 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; /
6.3.3 Running ADDM in Partial Mode → To 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; /
6.3 Diagnosing Database Performance Problems with ADDM → To 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.
6.3.1 Running ADDM in Database Mode → For 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
Running ADDM Manually → By 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.
Responding to ADDM Performance Findings → You 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
Diagnosing Performance Problems Using ADDM → ADDM 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
6.1.2 Using ADDM with Oracle Real Application Clusters → If 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
Viewing a Summary of ADDM Performance Findings → ADDM 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
Automatic Database Diagnostic Monitor (ADDM) → See ADDM. Automatic Diagnostic Repository (ADR) See ADR.
ADDM Analysis → An 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
ADDM Recommendations → In 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