Home » RDBMS Server » Performance Tuning » row cache lock: Cache id 8 - dc tables on QUERIES.
row cache lock: Cache id 8 - dc tables on QUERIES. [message #65876] Mon, 17 January 2005 22:39
Jonas Rosenthal
Messages: 4
Registered: January 2005
Junior Member
Hello,

I have observed users waiting on a row cache locke (cache id 8 which is dc_objects) while selecting from a table. The wait occurs for about 30 seconds. The getmiss ratio is about 5% for cache id 8.

First, Why would dc_objects need to be updated during a query? Weird.

Thank You,

Jonas Rosenthal

Report message to a moderator

Previous Topic: Required Index .(Urgent help)
Next Topic: Index not being used for query
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 23:21:45 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.