Can anything be Done about the following Values in report.txt or are they to
be Ignored :-
> 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
> spent
> 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 15093692 272995763 18.09
> SQL*Net more data from client 178154 523720 2.94
Received on Wed Sep 20 2000 - 08:03:20 CDT
