Re: sysptprof

In article <6a4v7j$ddm@cssun.mathcs.emory.edu>, Lester Knutsen <lester@advancedatatools.com> writes >Hi, > >Bill Ennis wrote: >> I have a question on the sysptprof table in systables. The manual >> says that profile information is available only when a table is >> open. Does this mean that rows are deleted from this table when >> no users are accessing OR does it mean that some information >> within ome of the columns is not available when it is open. > >I think this means that only tables that have been used and are >cached in shared memory (the Tblspace table structure) are in >this SMI table. If you have a 1000 tables on disk, and only 400 >have been accessed then this table will only contain 400 rows. >Rows stay in this table until the shared memory space is required >by another table. Even if no user has a table open, its information This sounds reasonable. Sorry to question but since in 7.10.UC1 the TBLSPACES parameter no longer exists in ONCONFIG and it is now dynamic I wonder if perhaps the space occupied by one table is never reused? This is a good question. I assume this space is in a virtual segment since it is dynamic. Hence since you cannot force it to be resident. Does Online just plan that if all the entries on a UNIX page are not used they will just get paged out and hence have no influence on the performance of Online? Of course each structure is a lot less than 1K 1000 tables is only 1Mb! >may still be cached in the tblspace structure and you can access it >via this SMI table. > >Regards - Lester > >______________________________________________________________________ >Lester Knutsen lester@advancedatatools.com >Advanced DataTools Corporation Voice: 703-256-0267 >Grant group privileges for Informix databases with DB Privileges >Visit our Web page: www.advancedatatools.com >Washington Area Informix User Group: www.iiug.org/~waiug/ >______________________________________________________________________ -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care