help on reading real time from utlstat

From: Melgar <luis_melgar_at_yahoo.com>
Date: 11 Jan 2006 12:19:21 -0800
Message-ID: <1137010761.654790.296590@o13g2000cwo.googlegroups.com>

this is a real silly question, but here i go.

i have this bad coded program that is making a lot of network traffic.

the Remark says that total times are in hundreths of secconds.

but i cant make sense of that number (althoug its ovbius that is really high).

178802867 since its hundreds it should be

1788028 real seconds then 1788028/60

29800 minutes? it doesnt seem right since....

START_TIME END_TIME

------------------ ------------------

11-jan-06 09:30:08 11-jan-06 11:30:04

then my actual question is..... the numbers are in miliseconds? miliseconds would make sense.

and the real number in minutes shall be....

29.80 minutes waiting for SQL*Net message from client.

Someone enlight me please

: \

---

SVRMGR> Rem System wide wait events for non-background processes (PMON, SVRMGR> Rem SMON, etc). Times are in hundreths of seconds. Each one of
SVRMGR> Rem these is a context switch which costs CPU time. By looking at
SVRMGR> Rem the Total Time you can often determine what is the bottleneck
SVRMGR> Rem that processes are waiting for. This shows the total time spen
SVRMGR> Rem waiting for a specific event and the average time per wait on

SVRMGR> Rem that event.
SVRMGR> select  n1.event "Event Name",
     2>         n1.event_count "Count",
     3>         n1.time_waited "Total Time",
     4>         round(n1.time_waited/n1.event_count, 2) "Avg Time"
     5>    from stats$event n1
     6>    where n1.event_count > 0
     7>    order by n1.time_waited desc;
Event Name                       Count         Total Time    Avg Time
-------------------------------- ------------- -------------
-------------
SQL*Net message from client             554879     178802867

322.24

...
...

..
START_TIME END_TIME

------------------ ------------------

11-jan-06 09:30:08 11-jan-06 11:30:04 Received on Wed Jan 11 2006 - 14:19:21 CST