 |
|
ss
Oracle Tips by Burleson |
Structure of
dba_advisor_findings
The task_id field can be used to gather more
information about a specific task. These findings can be in one of
four categories as shows in the type field:
-
Problem
-
Symptom
-
Error
-
Information
These categorizations provide a triage area
to look at the PROBLEM items first. These are the items where the
type is set to the string PROBLEM. A DBA allowing ADDM to advise on
database performance issues will, ideally, work their way down to
review and address the INFORMATION items.
The script show_addm_findings.sql will list
the items in the PROBLEM category. Figure 10.5 is a sample of the
output from this script when dealing with a CPU bottleneck issue.
* show_addm_findings.sql
--
*************************************************
-- Copyright © 2003 by Rampant TechPress
-- This script is free for non-commercial
purposes
-- with no warranties. Use at your own
risk.
--
-- To license this script for a commercial
purpose,
-- contact rtp AT rampant.cc
--
*************************************************
/* show_addm_findings.sql */
set lines 132
set pages 99
column task_name format a23
column impact_type format a40
column message format a100 WRAP
select
task_name,
type,
impact_type,
impact,
message
from
dba_advisor_findings
where:
See Code Depot
The above book excerpt is from:
Oracle Wait Event Tuning
High Performance with Wait
Event Iinterface Analysis
ISBN 0-9745993-7-9
Stephen Andert
http://www.rampant-books.com/book_2004_2_wait_tuning.htm |
