0 Replies Latest reply: Aug 30, 2013 9:21 AM by 1001703 RSS

    How can the performance of refresh cache group be monitored

    1001703

      Hi

       

      There was an error while refresh 200 thousand records into IMDB read only cache group from oracle

       

      The error

      6003: Lock request denied because of time-out

      Details: Tran 1.587 (pid 32752) wants X lock on rowid BMUFVUAAAA7AAAAMgi, table SYS.CACHE_GROUP. But tran 2.3757 (pid 27194) has it in Sn (request was Sn). Holder SQL (CALL ttCacheLockCacheGp(1, '3875528#', 'S', '1'))

      status changed to on

       

      1. What are the meta data table to be observed in oracle and timesten if IMDB cache is setup ?

      2. While creation of cache group,  will index be created if the primary key is mentioned in the creation statement. if yes , where can i found that metadata info?

      3. How can the performance of refresh cache group be monitored ?

      4. Are there any metadata table that catch the performance of refresh cache group ?

       

      Regards

      Siva Kumar