Re: Info on IO related to one Online table

Poul Pedersen (pp@q8.dk) wrote: : Subject: Info on IO related to one Online table. : ------------------------------------------------- : How is it possible to get info on disk reads/writes and buffer reads/writes : related to one table when more than one table are placed in a DbSpace ? : Do you have any input that might help me ? Tough one..... I know of no way to do it unless you have the table in its own dbspace. Maybe you could create a new dbspace and move it there, then watch with tbstat -D. Another option if your table is in a dbspace with others is to place a lock on all the other tables and assume that all activity is then for one table. Of course, this may not be practical. : Thanks from: : ----------------------------------------------------------------- : Databaseadministrator Poul Pedersen : Kuwait Petroleum (Danmark) A/S : Hummeltoftevej 49 Mail: pp@q8.dk : 2830 Virum Voice: +45 45 98 45 94 : Denmark Fax: +45 42 85 14 18 : ----------------------------------------------------------------- -- =========================================================================== jlumbley@netcom.com (Joe Lumbley) "If you believe that my statements Database Administrator represent my company, please send The Tigon Corporation money and I'll send you stock" Dallas, Texas Watch for my _INFORMIX DBA SURVIVAL GUIDE_ in Fall '94 from Prentice Hall! ===========================================================================