Re: sysptprof

Thanks Art. That may be it, I'll have to figure out for sure how to tell when all the buffers have been overwritten. The onstat -P doesn't do it. As soon as I stop reading from a table, there is no more entry for that table in the onstat -P. ======================== -<<Floyd Wellershaus>>- Database Administrator Unix Administrator email: fwellers@yahoo.com Home: 703-430-0805 Cell: 703-477-6045 ======================== http://www.one.org/ ----- Original Message ---- From: Art S. Kagel <kagel@bloomberg.net> To: informix-list@iiug.org Cc: informix-list@iiug.org Sent: Tuesday, November 21, 2006 10:44:56 AM Subject: Re: sysptprof Floyd Wellershaus wrote: > I am writing some benchmark scripts to keep track of chunk and table IO. > According to the manual, the following is true about sysmaster:sysptprof > > > The *sysptprof* table lists information about a tblspace. Tblspaces > correspond to tables. > > Profile information for a table is available only when a table is open. > When the last user who has a table open closes it, the tblspace in > shared memory is freed, and any profile statistics are lost. <SNIP> IB that the table remains 'open' as long as there are pages from the table in the buffer cache. Once the pages have aged out of the cache then the table should close and the stats would be lost. You can test this by doing your initial reads, then close that session and leave the table alone for a while, then read more pages from some other table than there are cache pages to force the table's pages out of the cache (you can check with onstat -P to make sure that all pages from the table's and its index's partnums are gone). Art S. Kagel _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list