RE: wait events

--openmail-part-0925da85-00000001

Content-Type: text/plain; charset=US-ASCII; name="BDY.TXT"
Content-Disposition: inline; filename="BDY.TXT"
Content-Transfer-Encoding: 7bit

>Check the ratio 'db file sequential reads' to 'table fetch by rowid'
for
>each session. If the ratio is GT 10% then you may have excessive
>fragmentation in an index. The solution is to rebuild the index.

>Steve.

Steve,

How do you compare a WAIT statistic, i.e. 'db file sequential reads' from V$SESSION_EVENT (which is a measure of number of waits/timeouts/time waited) to a EVENT count from V$SESSTAT i.e. 'table fetch by rowid'? In other words the wait statistics provides an indication of how many times a session waited, not how many times it occured... Do you see what I mean?

Not trying to beat down your argument, just trying to follow the thought. Was this from a document somewhere?

Cheers,
John Kanagaraj
Brunei Shell Petroleum
http://www.geocities.com/john_sharmila

God so loved the world that He didn't send a committee! (See John 3:16 for details)
** Opinions expressed here are solely mine and not necessarily those of my employer **

--openmail-part-0925da85-00000001

Content-Type: application/ms-tnef; name="WINMAIL.DAT"
Content-Disposition: attachment; filename="WINMAIL.DAT"
Content-Transfer-Encoding: base64

eJ8+IhGoAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5N aWNyb3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEDkAYADAAAAAEAAAADABcAAQAA ABwAAQOQBgAMAAAAAQAAAAMANgAAAAAAOgABBIABABAAAABSRTogd2FpdCBldmVudHMAWwUB A5AGAAwAAAABAAAACwACAAEAAAAPAAEDkAYAEAAAAAEAAABAADkAAOFnEmnAvwG9AwEDkAYA JAAAAAEAAAAeAEIAAQAAABIAAABKb2huIEouIEthbmFnYXJhagAAADsGAQOQBgAQAAAAAQAA AEAASAAAEOwTacC/AYEDAQOQBgAgAAAAAQAAAB4AcAABAAAAEAAAAFJFOiB3YWl0IGV2ZW50 cwD7BQEDkAYAKAAAAAEAAAACAXEAAQAAABYAAAABv8BpEmZfAjBVLEsR1JNDAGCXmRGzAABZ CAEDkAYADAAAAAEAAAADAAYQvs1MJBUCAQOQBgAMAAAAAQAAAAMABxD6AgAAFwEBA5AGAHgA AAABAAAAHgAIEAEAAABlAAAAQ0hFQ0tUSEVSQVRJT0RCRklMRVNFUVVFTlRJQUxSRUFEU1RP VEFCTEVGRVRDSEJZUk9XSURGT1JFQUNIU0VTU0lPTklGVEhFUkFUSU9JU0dUMTAlVEhFTllP VU1BWUhBVkVFWAAAAACcHQEDkAYADAAAAAEAAAADABAQAQAAACUAAQOQBgAMAAAAAQAAAAMA ERAAAAAAJQABA5AGABAAAAABAAAAQAAHMHCqtg1owL8BPQQBA5AGABAAAAABAAAAQAAIMHCq tg1owL8BPgQBA5AGACAAAAABAAAAAgELMAEAAAAQAAAAUzACX0ss1BGTQwBgl5kRs7oFAQOQ BgAMAAAAAQAAAAMA3j+vbwAAPwIBA5AGACQAAAABAAAAAwD+gQggBgAAAAAAwAAAAAAAAEYA AAAAEIUAAAAAAABMAwEDkAYAJAAAAAEAAAADAP+BCCAGAAAAAADAAAAAAAAARgAAAAABhQAA AAAAAD4DAQOQBgAkAAAAAQAAAAMAAIIIIAYAAAAAAMAAAAAAAABGAAAAABGFAAAAAAAAUAIB A5AGACQAAAABAAAAAwABggggBgAAAAAAwAAAAAAAAEYAAAAAUoUAAOMVAACKAwEDkAYALAAA AAEAAAAeAAKCCCAGAAAAAADAAAAAAAAARgAAAABUhQAAAQAAAAQAAAA4LjUAUAMBA5AGACQA AAABAAAACwADggggBgAAAAAAwAAAAAAAAEYAAAAABoUAAAAAAABQAgEDkAYAJAAAAAEAAAAL AASCCCAGAAAAAADAAAAAAAAARgAAAAAOhQAAAAAAAFkCAQOQBgAkAAAAAQAAAAMABYIIIAYA AAAAAMAAAAAAAABGAAAAABiFAAAAAAAAXAIBA5AGACwAAAABAAAAHgAGggggBgAAAAAAwAAA AAAAAEYAAAAANoUAAAEAAAABAAAAAAAAAJgCAQOQBgAsAAAAAQAAAB4AB4IIIAYAAAAAAMAA AAAAAABGAAAAADeFAAABAAAAAQAAAAAAAACaAgEDkAYALAAAAAEAAAAeAAiCCCAGAAAAAADA AAAAAAAARgAAAAA4hQAAAQAAAAEAAAAAAAAAnAIBA5AGACQAAAABAAAACwAJggsgBgAAAAAA wAAAAAAAAEYAAAAAAIgAAAAAAABWAgEDkAYAJAAAAAEAAAALAAqCCyAGAAAAAADAAAAAAAAA RgAAAAAFiAAAAAAAAFwCAQOQBgAUAAAAAQAAAB4APQABAAAAAQAAAAAAAABeAAEDkAYADAAA AAEAAAADAIAQ/////5AEAQkABAACAAAAAAAAAAEDkAYADAAAAAEAAAALACMAAAAAAC8AAQOQ BgAMAAAAAQAAAAsAKQAAAAAANQABBJAGAAQCAAABAAAAEgAAAAMAADACAAAACwAPDgAAAAAC Af8PAQAAAEcAAAAAAAAAgSsfpL6jEBmdbgDdAQ9UAgAAAQBvcmFjbGUtbEBmYXRjaXR5LmNv bQBTTVRQAG9yYWNsZS1sQGZhdGNpdHkuY29tAAAeAAIwAQAAAAUAAABTTVRQAAAAAB4AAzAB AAAAFQAAAG9yYWNsZS1sQGZhdGNpdHkuY29tAAAAAAMAFQwBAAAAAgH5DwEAAABHAAAAAAAA AIErH6S+oxAZnW4A3QEPVAIAAAEQb3JhY2xlLWxAZmF0Y2l0eS5jb20AU01UUABvcmFjbGUt bEBmYXRjaXR5LmNvbQAAAwD+DwYAAAAeAAEwAQAAABcAAAAnb3JhY2xlLWxAZmF0Y2l0eS5j b20nAAACAQswAQAAABoAAABTTVRQOk9SQUNMRS1MQEZBVENJVFkuQ09NAAAAAwAAOQAAAAAL AEA6AAAAAAMAcToAAAAAHgD2XwEAAAAVAAAAb3JhY2xlLWxAZmF0Y2l0eS5jb20AAAAAAgH3 XwEAAABHAAAAAAAAAIErH6S+oxAZnW4A3QEPVAIAAAEAb3JhY2xlLWxAZmF0Y2l0eS5jb20A U01UUABvcmFjbGUtbEBmYXRjaXR5LmNvbQAAAwD9XwEAAAADAP9fAAAAAAIB9g8BAAAABAAA Received on Wed May 17 2000 - 20:33:33 CDT