Why would sysptprof have 0 entries for all counters?
Gary Andrus found sysptprof showing all zeros on 14.10.FC10 despite over 200,000 sequential scans in the profile. Art Kagel had never seen this. Mike Walker asked about TBLSPACE_STATS in the onconfig; Gary found it had been turned off, which was the cause.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
I have looked at a client's sysptprof in search of some sequential scan information and found all entries in the table to be 0. The profile stats show over 200,000 sequential scans since the last profile reset. Then I ran a Select MAX() against every column in sysptprof. They are all 0. Similar situation is occurring in their Dev, QA, and Prod environments. The client is running 14.10.FC10 on GNU/Linux. What could be causing these entries to all be 0? I don't recall ever seeing this. Even after a reset, the buffer counters start rising (almost) immediately. ------------------------------ Gary Andrus ------------------------------
with 14.10.FC10 it could be anything :-P
I've never seen something like that. I query that table for Health Checks all the time on various versions. The table is properly populating as expected in v15.0 as well. ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------------------------
What is TBLSPACE_STATS set to in your onconfig? ------------------------------ Mike Walker xDB Systems, Inc www.xdbsystems.com ------------------------------
Thanks Mike. I don't recall ever having seen it shut off before so didn't even think to look at this. That was the issue. ------------------------------ Gary Andrus ------------------------------