who is reading data (just now) and what statement by ?

Hi, IDS 7.31UC6, HP-UX 10.20. I'd like to know, for who and what statement IDS is reading amount of data. I'd like to find why I see quite huge and long time taking reads ... Is this possible ? Thank you, Michal Hajek -- -------------------------------------------------------------- Michal Hajek mailto:hajek@nspuh.cz --------------------------------------------------------------

onstat -g sql Jean-Guy "Michal Hajek" <hajek@nspuh.cz> a 'crit dans le message news: 39B63A89.2C85B2F5@nspuh.cz... > Hi, > > IDS 7.31UC6, HP-UX 10.20. > > I'd like to know, for who and what statement IDS is reading > amount of data. I'd like to find why I see quite huge and long > time taking reads ... > > Is this possible ? > > Thank you, > Michal Hajek > > > -- > -------------------------------------------------------------- > Michal Hajek mailto:hajek@nspuh.cz > --------------------------------------------------------------

Michal Hajek wrote: > Hi, > > IDS 7.31UC6, HP-UX 10.20. > > I'd like to know, for who and what statement IDS is reading > amount of data. I'd like to find why I see quite huge and long > time taking reads ... > > Is this possible ? > > Thank you, > Michal Hajek > > > -- > -------------------------------------------------------------- > Michal Hajek mailto:hajek@nspuh.cz > -------------------------------------------------------------- Would onstat -g sql <sid> be what you were looking for? Will

William Rice wrote: > Michal Hajek wrote: > > I'd like to know, for who and what statement IDS is reading > > amount of data. I'd like to find why I see quite huge and long > > time taking reads ... > > Would onstat -g sql <sid> > be what you were looking for? > Hi ! Yes, but only as a second step..... I have more the 150 users active and as first step I need to know for who is IDS reading the biggest amount of data... Then I can use -g sql. Thanks, Michal -- -------------------------------------------------------------- Michal Hajek mailto:hajek@nspuh.cz --------------------------------------------------------------

onstat -u and look at the nreads column or even sort on it: onstat -u | sort +64d -74 Art S. Kagel Michal Hajek wrote: > > William Rice wrote: > > Michal Hajek wrote: > > > I'd like to know, for who and what statement IDS is reading > > > amount of data. I'd like to find why I see quite huge and long > > > time taking reads ... > > > > Would onstat -g sql <sid> > > be what you were looking for? > > > > Hi ! > Yes, but only as a second step..... > I have more the 150 users active and as first step I need > to know for who is IDS reading the biggest amount of data... > Then I can use -g sql. > > Thanks, > Michal > > -- > -------------------------------------------------------------- > Michal Hajek mailto:hajek@nspuh.cz > --------------------------------------------------------------