What sysmaster tables are used to produce nreads and nwrites columns
Hello gurus,
Could some one tell me the sysmaster table that is used to produce the
'nreads' and 'nwrites' columns from the onstat -u output. (The last 2 columns
of the onstat -u).
Thanks a lot.
---------------------------------
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing
↪ replying to Mike Smith
You can
get it by doing the following;
select pagreads, pagwrites
from syssesprof;
To get the user name with it you will have to join to syssession;
select ss.username, sp.pagreads. sp.pagwrites
from syssesprof sp, syssession ss
where sp.sid = ss.sid