Re: v$session_event questions

On Wed, 15 Oct 1997 01:07:44 GMT, hansenrd_at_cadvision.com (Richard Hansen) wrote:

>I am trying to determine the meaning of the data in v$session_event,
>especially for event = 'SQL*Net message from client' and 'SQL*Net
>message to client'.
>
>Our database appears to be getting a large amount of waits for these
>events (event = 'db file scattered read' and 'db file sequential read'
>are also high).
>
>What problems could these events be symptomatic of?

The presence of large numbers of waits for these events is not a problem, however, the average time waited may be. For example, the 'db file sequential read' waits should be less than 2 hundredths of a second on most disk subsystems.

>Also, what unit of measurement is time_waited reported in?

The unit is hundredths of a second. The paper on v$session_wait available at OraPub (http://www.europa.com/~orapub) claims that the unit is milliseconds, which is wrong (unless it has been corrected since I last looked).

Regards, Steve Adams
steve_adams_at_acslink.net.au (remove the underscore) Received on Wed Oct 15 1997 - 00:00:00 CDT