how to check high read or write usage on table in sybase 16

Question

I want which table have most read or write process in Sybase 16 in linux

I want which table have most read or write process in Sybase 16 in linux

Answer 1

Assuming you're working with the Sybase ASE product you might want to start with the MDA table (master..)monOpenObjectActivity which maintains several counters including logical/physical (page) reads, number of rows inserted/updated/deleted, etc.

For more details on setting up, configuring and using MDA tables see the Performance & Tuning Series: Monitoring Tables manual.