There was an error while refresh 200 thousand records into IMDB read only cache group from oracle
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 ?