| ID | ADVISOR_NAME | FINDING_NAME |
1 | 0 | Default Advisor | normal, successful completion |
2 | 1 | ADDM | "Administrative" Wait Class |
3 | 2 | ADDM | "Application" Wait Class |
4 | 3 | ADDM | "Cluster" Wait Class |
5 | 4 | ADDM | "Concurrency" Wait Class |
6 | 5 | ADDM | "Configuration" Wait Class |
7 | 6 | ADDM | "Network" Wait Class |
8 | 7 | ADDM | "Other" Wait Class |
9 | 8 | ADDM | "Scheduler" Wait Class |
10 | 9 | ADDM | "User I/O" wait Class |
11 | 10 | ADDM | Buffer Busy |
12 | 11 | ADDM | Buffer Cache Latches |
13 | 12 | ADDM | Checkpoints Due to DROP or TRUNCATE |
14 | 13 | ADDM | Checkpoints Due to Log File Size |
15 | 14 | ADDM | Checkpoints Due to MTTR |
16 | 15 | ADDM | Checkpoints Due to Parallel Queries |
17 | 16 | ADDM | Checkpoints Due to Tablespace DDL |
18 | 17 | ADDM | Commits and Rollbacks |
19 | 18 | ADDM | CPU Usage |
20 | 19 | ADDM | DBMS_LOCK Usage |
21 | 20 | ADDM | DBMS_PIPE Usage |
22 | 21 | ADDM | Excessive Rebinds |
23 | 22 | ADDM | Free Buffer Waits |
24 | 23 | ADDM | Hard Parse |
25 | 24 | ADDM | Hard Parse Due to Invalidations |
26 | 25 | ADDM | Hard Parse Due to Literal Usage |
27 | 26 | ADDM | Hard Parse Due to Parse Errors |
28 | 27 | ADDM | Hard Parse Due to Sharing Criteria |
29 | 28 | ADDM | High Watermark Waits |
30 | 29 | ADDM | I/O Throughput |
31 | 30 | ADDM | Index Block Split |
32 | 31 | ADDM | Global Cache Busy |
33 | 32 | ADDM | Global Cache Congestion |
34 | 33 | ADDM | Interconnect Latency |
35 | 34 | ADDM | Global Cache Lost Blocks |
36 | 35 | ADDM | Global Cache Messaging |
37 | 36 | ADDM | Global Cache Multiblock Requests |
38 | 37 | ADDM | ITL Waits |
39 | 38 | ADDM | Java Execution |
40 | 39 | ADDM | Latch Free Waits |
41 | 40 | ADDM | Log File Switches |
42 | 41 | ADDM | PL/SQL Compilation |
43 | 42 | ADDM | PL/SQL Execution |
44 | 43 | ADDM | RMAN I/O |
45 | 44 | ADDM | Row Lock Waits |
46 | 45 | ADDM | Sequence Usage |
47 | 46 | ADDM | Session Connect and Disconnect |
48 | 47 | ADDM | Session Slot Scheduling |
49 | 48 | ADDM | Shared Pool Latches |
50 | 49 | ADDM | Slow Archivers |
51 | 50 | ADDM | Soft Parse |
52 | 51 | ADDM | Space Transaction Waits |
53 | 52 | ADDM | Streams Flow Control |
54 | 53 | ADDM | Table Locks |
55 | 54 | ADDM | Temp Space Contention |
56 | 55 | ADDM | Top Segments by I/O |
57 | 56 | ADDM | Top SQL by "Cluster" Wait |
58 | 57 | ADDM | Top SQL by DB Time |
59 | 58 | ADDM | Top SQL By I/O |
60 | 59 | ADDM | Undersized Buffer Cache |
61 | 60 | ADDM | Undersized PGA |
62 | 61 | ADDM | Undersized Redo Log Buffer |
63 | 62 | ADDM | Undersized SGA |
64 | 63 | ADDM | Undersized Shared Pool |
65 | 64 | ADDM | Undersized Streams Pool |
66 | 65 | ADDM | Undo I/O |
67 | 66 | ADDM | Unusual "Administrative" Wait Event |
68 | 67 | ADDM | Unusual "Application" Wait Event |
69 | 68 | ADDM | Unusual "Cluster" Wait Event |
70 | 69 | ADDM | Unusual "Commit" Wait Event |
71 | 70 | ADDM | Unusual "Concurrency" Wait Event |
72 | 71 | ADDM | Unusual "Configuration" Wait Event |
73 | 72 | ADDM | Unusual "Network" Wait Event |
74 | 73 | ADDM | Unusual "Other" Wait Event |
75 | 74 | ADDM | Unusual "Scheduler" Wait Event |
76 | 75 | ADDM | Unusual "User I/O" Wait Event |
77 | 76 | ADDM | Virtual Memory Paging |
78 | 77 | ADDM | Unusual "Queueing" Wait Event |
79 | 78 | ADDM | "Queueing" Wait Class |
80 | 79 | ADDM | Undersized instance memory |
81 | 80 | ADDM | Top SQL Statements |
82 | 81 | ADDM | Top Segments by "User I/O" and "Cluster" |
83 | 82 | ADDM | Buffer Busy - Hot Block |
84 | 83 | ADDM | Buffer Busy - Hot Objects |