Re: Anybody good at EM? What's the meaning of "Remaining Waits" shown in EM?

qihua wu wrote:
>
> What's "Remaining Waits"?
>
> OEM 10g shows us that a sql consumes lots of time, and the breakdown is
> Application Waits(0.1%)
> Cluster Waits(3.7%)
> Concurrency Waits(0.2%)
> Remaining Waits(52%)
> User I/O Waits(21.6%)
> CPU(22.3%)
>
> But what's "Remaining Waits" which consume the majority of the time?
> there is no definition on otn or metalink.
>
> The information in another section in EM is:
> Activity By Time
> Elapsed Time (sec) 3,559.97
> CPU Time (sec) 795.54
> Wait Time (sec) 2,764.43
> Here we only have "wait time", and we can see "wait time" take up more
> than 75% of the total time. I am wondering whether "wait time"(in the
> section)="User I/O Waits"+"Remaining Waits" (in another section)
>

while this is not a RAC db, I suppose that Other wait class is hidden under Remaining waits (90% of probability), though it can be also sum of all waits on wait classes other then provided explicitly (10%)
(unfortunately I guess, no RAC instance here)

SQL:S_REMS_at_poligon.world> select * from v$system_wait_class;

WAIT_CLASS_ID WAIT_CLASS#
WAIT_CLASS TOTAL_WAITS TIME_WAITED

------------- ----------- 
---------------------------------------------------------------- 
----------- -----------
   1893977003           0 
Other                                                                   
9747      452049
   4217450380           1 
Application                                                             
1272        3990
   3290255840           2 
Configuration                                                        
5778312     1064875
   3875070507           4 
Concurrency                                                             
2253      122248
   3386400367           5 
Commit                                                                 
23767      718005
   2723168908           6 
Idle                                                                 
3980631   564967560
   2000153315           7 
Network                                                              
2974767        2128
   1740759767           8 User 
I/O                                                              
321770      579248
   4108307767           9 System 
I/O                                                            
302777     4261446

-- 

------------------------------------------------------------------------
Remigiusz Sokolowski <rems_at_wp-sa.pl>
WP/PTI/DIP/ZAB (+04858) 52 15 770
MySQL v04.x,05.x; Oracle v10.x

Zastrzezenia:
1. Wylaczenie danej funkcjonalnosci oznacza, ze niezwlocznie przystapimy
   lub juz pracujemy nad jej uruchomieniem
2. Niniejsza wiadomosc stanowi jedynie wyraz prywatnych pogladow autora 
   i nie jest w zadnym wypadku zwiazana ze stanowiskiem przedsiebiorstwa 
   Wirtualna Polska S.A.
------------------------------------------------------------------------



WIRTUALNA  POLSKA  SA, ul. Traugutta 115c, 80-226 Gdansk; NIP: 957-07-51-216; 
Sad Rejonowy Gdansk-Polnoc KRS 0000068548, kapital zakladowy 62.880.024 zlotych (w calosci wplacony)
--
http://www.freelists.org/webpage/oracle-l