tag:blogger.com,1999:blog-20612393.post2413117931915818320..comments2023-09-29T21:26:11.876+07:00Comments on Surachart Opun's Blog: Investigate ROW CACHE LOCKSurachart Opunhttp://www.blogger.com/profile/05646896104906516714noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-20612393.post-59191479044493977042011-09-26T16:55:05.446+07:002011-09-26T16:55:05.446+07:00very good blog,for me a concurrent job waiting wit...very good blog,for me a concurrent job waiting with row cache lock,used your analysis,i got as below;<br /><br />SQL> select PARAMETER ,COUNT ,GETS ,GETMISSES ,MODIFICATIONS from v$rowcache where cache#=8;<br /><br />PARAMETER COUNT GETS GETMISSES MODIFICATIONS<br />-------------------------------- ---------- ---------- ---------- -------------<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-20612393.post-35469828255033484252010-10-05T21:26:43.922+07:002010-10-05T21:26:43.922+07:00please check on
http://forums.oracle.com/forums/t...please check on <br />http://forums.oracle.com/forums/thread.jspa?threadID=1544430&tstart=0Surachart Opunhttps://www.blogger.com/profile/05646896104906516714noreply@blogger.comtag:blogger.com,1999:blog-20612393.post-21712398398699933932010-10-05T20:58:41.501+07:002010-10-05T20:58:41.501+07:00Hi,
Very good blog. In my awr top 5 events showed...Hi,<br /><br />Very good blog. In my awr top 5 events showed row cache lock.Used your analyzis to get the parameter<br /><br />SQL> select PARAMETER ,COUNT ,GETS ,GETMISSES ,MODIFICATIONS from v$rowcache where cache#=16;<br /><br />PARAMETER COUNT GETS GETMISSES MODIFICATIONS<br />-------------------------------- ---------- ---------- ---------- -------------Baskarhttps://www.blogger.com/profile/15416034348562107938noreply@blogger.com