Re: How to identify sql (and to a lesser extent sessions) contributed to sql*net bytes ,sorts, redo bytes, etc?
- From: Yong Huang <yong321@xxxxxxxxx>
- To: fmhabash@xxxxxxxxx
- Date: Fri, 17 Sep 2010 10:26:37 -0700 (PDT)
Other than the views inside Oracle, how about my topio program run on OS?
http://yong321.freeshell.org/freeware/pio.html
It sorts on delta of an I/O counter you choose, much like top does. Different
OS'es provide different counters. The one for Linux was added lately and I
haven't fully understood the meanings of all their counters.
Yong Huang
> Every once in a while I get confronted with a questions like what
> sql (and less importantly, sessions) caused bytes to be sent to/from
> the database, genereated most redo, or cause most extensive sort?
--
//www.freelists.org/webpage/oracle-l
Other related posts:
