Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2011
    Location
    USA
    Posts
    80

    Unanswered: Most active tables

    I was working on performance issue on one database and were looking for most active tables with the help of following query :

    SELECT
    SUBSTR(TABSCHEMA,1,10) AS SCHEMA,
    SUBSTR(TABNAME,1,20) AS NAME,
    TABLE_SCANS,
    ROWS_READ,
    ROWS_INSERTED,
    ROWS_DELETED
    FROM TABLE(MON_GET_TABLE('','',-1))
    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.

  2. #2
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    From the last database activation.
    Regards,
    Mark.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •