I was working on performance issue on one database and were looking for most active tables with the help of following query :
SUBSTR(TABSCHEMA,1,10) AS SCHEMA,
SUBSTR(TABNAME,1,20) AS NAME,
ORDER BY ROWS_READ DESC
FETCH FIRST 10 ROWS ONLY
I just wanted to know its provide information from database creation time or its provide information from last restart ? or any kind of purging is there.