關于sysmaster:sysptprof
看到系統會自動生成一個這樣的TABLE
不清楚里面存放的是什么數據,請高手幫助
從里面能看出什么呢??
[解决办法]
create table "sysmaster".sysptprof {表i/o概貌}
partnum integer, {表编号 }
tabname char(18), {表名 }
lockreqs integer, {锁请求 }
lockwts integer, {锁等待 }
deadlks integer, {死锁 }
lktouts integer, {锁超时 }
isreads integer, {读 }
iswrites integer, {写入 }
isrewrites integer, {改写 }
isdeletes integer, {删除 }
bufreads integerinteger, {缓冲区读}
bufwrites integer, {行冲区写}
seqscans integer, {顺序扫描}
pagreads integer, {磁盘读 }
pagwrites integer {磁盘写 }
);
grant select on sysptprof to public;