Re: Table io rate
Sean Wong wrote:
> Can somebody give me answers on following questions:
>
>1. How can I find out disk io, e.g. read/write access for a given table
>2. How can I find out disk io, e.g. read/write access for a process
1. Try this query on the sysmaster database. which I got from an
Informix person:
select dbaname, tabname,
sum(pagreads) reads,
sum(pagwrites) writes
from sysmaster:sysptprof
group by dbsname, tabname
;
2. By process, I assume you mean a session. Try this query in
sysmaster:
select sid,
isreads,
iswrites,
isrewrites,
isdeletes
from syssesprof
If you need the name of the user and some other stuff, like the process
ID of the client app, you can join the above table with syssessions (ie.
syssessions.sid = syssesprof.sid):
select p.sid, isreads, iswrites, isrewrites, isdeletes,
username, pid, tty
from syssesprof p, syssessions s
where p.sid = s.sid
--
-- Jake Salomon ()
. .
_..-'( )`-.._
./'. '||\\\\. }\\_/{ .//||` .`\\.
./'.|'.'||||\\\\|.. )o o( ..|//||||`.`|.`\\.
./'..|'.|| |||||\\`````` \\'@'/ ''''''/||||| ||.`|..`\\.
./'.||'.|||| ||||||||||||. | .|||||||||||| ||||.`||.`\\.
/'|||'.|||||| ||||||||||||{ | }|||||||||||| ||||||.`|||`\\
'.|||'.||||||| ||||||||||||{ | }|||||||||||| |||||||.`|||.`'.||| ||||||||| |/' ``\\||`` | ''||/'' `\\| ||||||||| |||.`
|/' \\./' `\\./ \\!|\\ /|!/ \\./' `\\./ `\\|
V V V }' `\\ /' `{ V V V
\\ \\ \\ V / / /
+-----------------------------------------------------------+
| Impeccable Logic: A thought process which successfully |
| resists chicken bites |
+-----------------------------------------------------------+