Information on contents of v$system_event view

Hello,

I have a question regarding the rows in the v$system_event view. Does any one have documentation on what to do with the info from this view. I know where to find the description of the view and it's columns, but I want
to know what the events mean.

desc v$system_event

Name                            Null?    Type
------------------------------- -------- ----
EVENT                                    VARCHAR2(64)
TOTAL_WAITS                      NUMBER
TOTAL_TIMEOUTS              NUMBER
TIME_WAITED                      NUMBER
AVERAGE_WAIT                 NUMBER

I especially have a question about the 'db file sequential read' row

The total time_waited for this event is extremely high when doing a couple of
selects. Example: I run two select statements which run over a total time of an 1/2 hour. After reading the parameter, it states that it has been waiting for
1200 seconds (20 minutes) and an average wait of 0.02.

The selects are done almost only by reading indexes and we almost certainly have an I/O bottleneck.

Can somebody please try and explain what is going on.

Thanks in advance.

John Received on Thu Apr 23 1998 - 15:00:21 CDT